About 1,347,060 results (4,224 milliseconds)
UNIQUE Function still displaying duplicate values from a list of ...
https://support.google.com/docs/thread/272555264/unique-function-still-displaying-duplicate-values-from-a-list-of-alphanumeric-characters?hl=en May 2, 2024 ... I have a list of part numbers that are alphanumeric characters. I am trying to remove all the duplicates on each row. When using the formula =unique(L2:P2) I ...
Re: Disable UDF from being called during the function wizard
https://groups.google.com/g/exceldna/c/l-9hHr4i_hg Feb 10, 2013 ... ... function Wizard. This seems to not work in excel 2013 but works just fine in excel 2010. Thanks Again for all your help. Pooja. Govert van ...
Unique function breaks when exporting to excel - Google Docs ...
https://support.google.com/docs/thread/100809573/unique-function-breaks-when-exporting-to-excel?hl=en Mar 4, 2021 ... I have created a spreadsheet that uses the Unique() function. This function is supported in both Microsoft 365 Excel and Google Sheets.
Problem using Data Validation to prevent duplicate entries in ...
https://support.google.com/docs/thread/150859914/problem-using-data-validation-to-prevent-duplicate-entries-in-google-sheets?hl=en Feb 15, 2022 ... I have put the Data Validation formula =countif(A$2:A2,A2)=1 ... use Excel but this stuff is with a group using google sheets. I have ...
VBA excel API not working with Windows 8 and Excel 2013?
https://groups.google.com/g/automateanalytics/c/NiEXc5GEbss Aug 7, 2013 ... Hi, I've been using the VBA excel API (http://www.automateanalytics.com/p/google-analytics-vba-functions.html) and it is such a great tool!
How to create a filter to exclude "False" results without using the ...
https://support.google.com/docs/thread/211969305/how-to-create-a-filter-to-exclude-false-results-without-using-the-manual-filter-feature?hl=en Apr 20, 2023 ... ... using the =filter function, but I'm really struggling with it. I figured something like =filter(A2:A1000,unique) would work because the unique ...
How do you list a range with unique values in one colomn - Google ...
https://support.google.com/docs/thread/184509475/how-do-you-list-a-range-with-unique-values-in-one-colomn?hl=en Oct 17, 2022 ... In a Google Sheets formula that uses the query() function and a computed array such as unique(Sheet1! ... In Excel you can: How to create ...
Analyze data - Google Docs Editors Help
https://support.google.com/docs/answer/9330962?hl=en Sheets: Copy and paste. Cut, copy, paste, and use the Format Painter in 2010 and 2013 versions. Excel 2013 and ...
UNIQUE ImportRange by first and last name - Google Docs Editors ...
https://support.google.com/docs/thread/103438524/unique-importrange-by-first-and-last-name?hl=en Mar 22, 2021 ... Then in another sheet use a formula to remove the duplicates. To best get help, please show your hand-entered expected results from the data in ...
Excel 2013 doesn't recognize add-in from Getting Started example
https://groups.google.com/g/exceldna/c/jaRk7bfD1Cc Sep 23, 2014 ... Then just double-click the Distribution\ExcelDna.xll file - it should load in Excel (probably with the prompt) and then give you a new function ...
My OFFSET, MATCH,COUNTIF Excel Formula won't work in Sheets ...
https://support.google.com/docs/thread/103447353/my-offset-match-countif-excel-formula-won-t-work-in-sheets?hl=en Mar 22, 2021 ... Top Contributor since 12 January 2013. Mar ... Microsoft Excel has traditionally not supported real array formulas like filter() or unique ...
ExcelDNA function for changing parameters
https://groups.google.com/g/exceldna/c/8E4h9NcAbFQ Apr 16, 2014 ... I have not yet tried this in Excel 2013, but I plan to do it. ... Perhaps my use case is unique or my server has a mistake in code. I ...
4. Analyse data in Sheets - Google Docs Editors Help
https://support.google.com/docs/answer/9330962?hl=en-GB Cut, copy, paste, and use the Format Painter in 2010 and 2013 versions. Excel 2013 and 2010 ... Most Excel functions are the same in Sheets. For a list of ...
Analyze data - Google Workspace Learning Center
https://support.google.com/a/users/answer/9330962?hl=en Sheets: Copy and paste. Cut, copy, paste, and use the Format Painter in 2010 and 2013 versions. Excel 2013 and ...
Complete Simple VB.Net sample for Excel 2013
https://groups.google.com/g/exceldna/c/dXDTEbdH4ks It's easy to put the code in a Class but forget to mark the function as “Shared” (the equivalent of “static” in C#). The simplest instructions for ...
How do I use the UNIQUE function for a range, while excluding ...
https://support.google.com/docs/thread/206112815/how-do-i-use-the-unique-function-for-a-range-while-excluding-specific-text-and-blank-spaces-sort?hl=en Mar 14, 2023 ... How do I use the UNIQUE function for a range, while excluding specific text and blank spaces, +sort? What is a good formula for this? Details.
Using PInvoke to access my C++ lib not working
https://groups.google.com/g/exceldna/c/1UAvimxVSsQ Feb 17, 2015 ... I have a simple project in MS VS 2013 to test accessing a simple C++ function in Excel, using P/Invoke and Excel-DNA.
ExcelDNA and Microsoft.Office.Interop.Excel
https://groups.google.com/g/exceldna/c/cGaa-X5vlE8 Nov 28, 2017 ... ... work on computer having an ealier version of Excel (2013 or 2010). ... how to use the XlCall and other functions, and the detail documentation ?
Use macros and add-ons - Google Docs Editors Help
https://support.google.com/docs/answer/9331168?hl=en Excel 2013 and 2010. Automate repetitive tasks with macros in Sheets. Or, if ... Use unique macro shortcuts. You can have up to 10 shortcuts per sheet ...
Problem using Excel 2007
https://groups.google.com/g/exceldna/c/i3h4p8HgLvA Mar 12, 2014 ... Govert van Drimmelen ... Hi Jon,. Your function looks fine, and should not behave differently in Excel 2007 vs 2013. One thing you might look out ...