Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a list that is going to constantly be changing. One time the list may
have 185 records & next time the list might have 18,212 records. I need to evaluate the values in a column & return a list of only the unique values in the column !!!without using filters, pivot tables or any menu items - it has to be formulas or arrays ONLY because my users wouldn't know how to handle the pivot tables or follow directions from the menu!!! For example... 3.03 3.03 3.5 3.57 3.99 3.99 3.99 4.0 4.0 4.1 4.3 4.33 The result would be: 3.03 3.5 3.57 3.99 4.0 4.1 4.3 4.33 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I paste a unique values list? | Excel Discussion (Misc queries) | |||
Array Formulas - Unique List from List with Duplicates | Excel Discussion (Misc queries) | |||
How to identify text from a autofiltered list using formulas | Excel Worksheet Functions | |||
Count unique values and create list based on these values | Excel Worksheet Functions | |||
create list of unique values from a column with repeated values? | Excel Worksheet Functions |