LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Identify & List unique values from a list using functions/formulas

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I paste a unique values list? jak roodi Excel Discussion (Misc queries) 14 April 22nd 23 08:10 AM
Array Formulas - Unique List from List with Duplicates Johnny Meredith Excel Discussion (Misc queries) 7 October 27th 06 09:26 PM
How to identify text from a autofiltered list using formulas Harryac Excel Worksheet Functions 1 July 13th 06 11:45 PM
Count unique values and create list based on these values vipa2000 Excel Worksheet Functions 7 August 5th 05 01:17 AM
create list of unique values from a column with repeated values? Chad Schaben Excel Worksheet Functions 1 July 8th 05 10:25 PM


All times are GMT +1. The time now is 06:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"