| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unique Values, not Unique Records
My data looks like the following:
ID Type Amt 1234 A $10.00 1234 B $10.00 1234 C $10.00 I would like to find a way to get only one of the items on to a new spreadsheet, because they are duplicate records in my eyes. The Advanced filter does not work because each record is unique. Can anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unique Values, not Unique Records
in the dialog for the advanced filter, make sure only the ID column is
referenced "steph44haf" wrote: My data looks like the following: ID Type Amt 1234 A $10.00 1234 B $10.00 1234 C $10.00 I would like to find a way to get only one of the items on to a new spreadsheet, because they are duplicate records in my eyes. The Advanced filter does not work because each record is unique. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filer for unique records and return all column data for unique rec | Excel Discussion (Misc queries) | |||
| delete duplicate values - leaving unique records only i.e. recordspresent once only | Excel Worksheet Functions | |||
| unique filter results in some non-unique records. | Excel Discussion (Misc queries) | |||
| Unique Records | Excel Discussion (Misc queries) | |||
| Unique Records | Excel Worksheet Functions | |||
Hybrid Mode
