| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering for Unique Records
I forgot to ad
If you only want to have unique records then only Advanced filter will work With the helper column you can use AutoFilter maybe for other things See this page for a Advanced example http://www.contextures.com/xladvfilter01.html#FilterUR Good luck -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Hi captculver Maybe you can create a new column that make one string of the 5 fields and filter for unique fields with Advanced filter Like this =A1&B1&C1&D1&E1 And copy down -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "captculver" wrote in message ... I'm working with a dataset of approx 2K records; each record has 15 fields. The uniqueness of each record is defined by 5 fields. Is there a way to filter for unique records given these conditions?? Thanks... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Flitering for unique records in Col B based on filtering in Col A | Excel Discussion (Misc queries) | |||
| filtering unique records ajit | Excel Discussion (Misc queries) | |||
| Filtering for Unique Records with multiple-column criteria | Excel Discussion (Misc queries) | |||
| unique filter results in some non-unique records. | Excel Discussion (Misc queries) | |||
| filtering for unique records | Excel Discussion (Misc queries) | |||
Threaded Mode
