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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Filter - extracting unique records
Advanced filter wants your data to have a header. If you don't have a header,
then it'll assume the first row of the range is the header. So if you don't have a header, add one, do your advanced filter and delete the header. Balan wrote: 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. -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Filter - extracting unique records
Many Thanks ! The problem is solved. I do not know why it didn't strike me.
Balan "Dave Peterson" wrote: Advanced filter wants your data to have a header. If you don't have a header, then it'll assume the first row of the range is the header. So if you don't have a header, add one, do your advanced filter and delete the header. Balan wrote: 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. -- Dave Peterson |
Reply |
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) |