Error using Advanced Filter Unique Records

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

 

[Peo Sjoblom]

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

 

[Guest]

OK mr. microsoft can do no wrong, have a look at my data at

http://www.headly.com/data.xls

TIA

 

[Peo Sjoblom]

These are the ones I got filtering

US Maidson
US Davis
US Ali
US Lee
US Backel
US Smith
US Jackson
US Brown



which one is a duplicate?


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Guest]

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?

 

[Debra Dalgleish]

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.