| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Filter - extracting unique records
I have a range of data. The leftmost column contains names, some of the
names being repeated in some of the rows. I used advanced filter to extract the unique names. I find that always the first name is shown twice, once at the top and again somewhere at the middle. How to avoid this repetition. This however happens only with the first name. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Live" Advanced Filter (for unique records) | Excel Discussion (Misc queries) | |||
| Advanced Filter/ Extracting Data | Excel Discussion (Misc queries) | |||
| Error using Advanced Filter Unique Records | Excel Discussion (Misc queries) | |||
| Extracting unique records by formula | Excel Discussion (Misc queries) | |||
| Inconsistent Results: Advanced Filter Unique Records Only | Excel Discussion (Misc queries) | |||
Threaded Mode
