Aug 5, 2024 · The UNIQUE function will provide either a list of unique or distinct values. =UNIQUE has three arguments: array, by_col and occurs_once. Only the array is required. If …

May 23, 2005 · Hi all. I am using the UNIQUE function on a column full of text and the last unique value being returned is a 0. I have this occurring in 2 different UNIQUE functions. How can I …

Nov 30, 2017 · Hi I am using the unique formula to extract a list of unique values from a table and I have to say I am a big fan of this formula having just discovered it. …

Mar 15, 2016 · Hi! Is it possible to use the new "unique" function on multiple non-contiguous arrays? If so, what would be the proper syntax to make it work? As an example: I'd like to do …

Aug 19, 2022 · Say that you want to filter the names in a column so you get just the unique rows sorted where the team in the other column is Blue.

Feb 23, 2020 · I have Office 2016 on my computer. I found out that the UNIQUE function and other new functions are not available for my version. I need to identify a unique number is a 2 …

May 2, 2021 · Has anyone tried to use VBA WorksheetFunction.Unique function in Ms Office 365? I use Ms Office 365, and the WorksheetFunction.Unique function is recognized...

Oct 7, 2022 · Hello! I need to count unique values based on two criteria and this is the formula I've come up with. It successfully gets what I want, EXCEPT it returns a 1 when it should be …

Aug 4, 2021 · hi everyone! long time no see, i'm having trouble using excel formula UNIQUE in a large number of rows, the example below, in col E, is working now, but when i'm trying to fill …

Feb 21, 2021 · Hi Everyone, I have attached a spreadsheet and highlighted in yellow the column K I would need to be filled with a formula (spill formula only so that it is completely automated). …