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.

headly wrote:
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.







--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html