| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I find and sort unique values from a column
hi,
I have a list of n number of values (i.e names and ID numbers). each unique value will have several entries (i.e the same ID number and name will exist multiple times) I want to sort the data so that the remains will be a single entry per unique value (i.e every name only pops up once) how do I do it? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I find and sort unique values from a column
Adavanced Filter/ Unique records only, then sort.
-- David Biddulph "spreadsheet monkey" wrote in message ... hi, I have a list of n number of values (i.e names and ID numbers). each unique value will have several entries (i.e the same ID number and name will exist multiple times) I want to sort the data so that the remains will be a single entry per unique value (i.e every name only pops up once) how do I do it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To find Multiple values in column B for a unique value in column A | Excel Worksheet Functions | |||
| How to Sort by Count the Max nos of Unique text values in Pivot Ta | Excel Discussion (Misc queries) | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| Populate a column by extracting unique values from another column? | Excel Worksheet Functions | |||
| How do I sort a column a unique number? | Excel Worksheet Functions | |||
Linear Mode
