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?

"Peo Sjoblom" wrote:

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


"headly" wrote in message
...
OK mr. microsoft can do no wrong, have a look at my data at

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

TIA

"Peo Sjoblom" wrote:

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



"headly" wrote in message
...
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.