Advanced Filter - extracting unique records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter Unique Values 6
Extracting unique entries 6
missing data w/ advanced filter 6
advanced filter: duplicate result 2
Unique records formula & zero entries 9
Automatically extracting unique values 5
Advanced Filter 1
Compare two datasets and extract unique records from each 3

Back
Top