| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying unique entries from a filtered list
Hello,
I'm working with a large database (5400 rows by 15 columns) of data, some text. I need to be able to display only unique entries after a list has been filtered for nonblanks. Eg. I filter a list and it gives me: Mechanic Mechanic Interior Maintenance Mechanic Interior Maintenance Janitor Plumber I want to be able to create a list of the unique positions after the filter, which will say Mechanic Interior Maintenance Janitor Plumber Thanks so much, S Davis |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| list unique values in a column | Excel Worksheet Functions | |||
| Comparing Entries to a list | Excel Worksheet Functions | |||
| counting unique entries in a list | Excel Discussion (Misc queries) | |||
| Define a range containing the first 10 rows of a filtered list | Excel Worksheet Functions | |||
| Can I compare 2 lists to combine duplicate entries in new list? | Excel Worksheet Functions | |||
Threaded Mode
