Error using Advanced Filter Unique Records

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

Guest

Have a list of 1000+ rows of data (countries). Use the adv filter unique to a
new region but still get duplicate values for US and a 'salesperson'. Tried
to trim to data, same result, brought into word and searched for a space,
same problem. Ideas appreciated.
 
I doubt it is an error, I have never experienced an error so either you must
apply it incorrectly or there are hidden characters, post a small sample in
text like

Header1 Header2 Header3
data data data etc


then post the criteria you are using

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
OK, I want to filter unique records from column a to a new range and then
filter the unique records from column b to a new range. When I do that I get
two US and two Maidson. Is my office installation corrupted?
 
Include the column heading cells when you specify the list range.
Otherwise the first entry will be treated as the heading, and may be
repeated.
 
Back
Top