software

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 etcthen post the criteria you are using

--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;headlyquot; gt; wrote in message
...
gt; Have a list of 1000 rows of data (countries). Use the adv filter unique
gt; to a
gt; new region but still get duplicate values for US and a 'salesperson'.
gt; Tried
gt; to trim to data, same result, brought into word and searched for a space,
gt; same problem. Ideas appreciated.
OK mr. microsoft can do no wrong, have a look at my data at

www.headly.com/data.xls

TIA

quot;Peo Sjoblomquot; wrote:

gt; I doubt it is an error, I have never experienced an error so either you must
gt; apply it incorrectly or there are hidden characters, post a small sample in
gt; text like
gt;
gt; Header1 Header2 Header3
gt; data data data etc
gt;
gt;
gt; then post the criteria you are using
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt;
gt; quot;headlyquot; gt; wrote in message
gt; ...
gt; gt; Have a list of 1000 rows of data (countries). Use the adv filter unique
gt; gt; to a
gt; gt; new region but still get duplicate values for US and a 'salesperson'.
gt; gt; Tried
gt; gt; to trim to data, same result, brought into word and searched for a space,
gt; gt; same problem. Ideas appreciated.
gt;
gt;
gt;

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

nwexcelsolutions.comquot;headlyquot; gt; wrote in message
...
gt; OK mr. microsoft can do no wrong, have a look at my data at
gt;
gt; www.headly.com/data.xls
gt;
gt; TIA
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; I doubt it is an error, I have never experienced an error so either you
gt;gt; must
gt;gt; apply it incorrectly or there are hidden characters, post a small sample
gt;gt; in
gt;gt; text like
gt;gt;
gt;gt; Header1 Header2 Header3
gt;gt; data data data etc
gt;gt;
gt;gt;
gt;gt; then post the criteria you are using
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; nwexcelsolutions.com
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;headlyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Have a list of 1000 rows of data (countries). Use the adv filter
gt;gt; gt; unique
gt;gt; gt; to a
gt;gt; gt; new region but still get duplicate values for US and a 'salesperson'.
gt;gt; gt; Tried
gt;gt; gt; to trim to data, same result, brought into word and searched for a
gt;gt; gt; space,
gt;gt; gt; same problem. Ideas appreciated.
gt;gt;
gt;gt;
gt;gt;
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?

quot;Peo Sjoblomquot; wrote:

gt; These are the ones I got filtering
gt;
gt; US Maidson
gt; US Davis
gt; US Ali
gt; US Lee
gt; US Backel
gt; US Smith
gt; US Jackson
gt; US Brown
gt;
gt;
gt;
gt; which one is a duplicate?
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;headlyquot; gt; wrote in message
gt; ...
gt; gt; OK mr. microsoft can do no wrong, have a look at my data at
gt; gt;
gt; gt; www.headly.com/data.xls
gt; gt;
gt; gt; TIA
gt; gt;
gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt;
gt; gt;gt; I doubt it is an error, I have never experienced an error so either you
gt; gt;gt; must
gt; gt;gt; apply it incorrectly or there are hidden characters, post a small sample
gt; gt;gt; in
gt; gt;gt; text like
gt; gt;gt;
gt; gt;gt; Header1 Header2 Header3
gt; gt;gt; data data data etc
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; then post the criteria you are using
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt;
gt; gt;gt; Regards,
gt; gt;gt;
gt; gt;gt; Peo Sjoblom
gt; gt;gt;
gt; gt;gt; nwexcelsolutions.com
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;headlyquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Have a list of 1000 rows of data (countries). Use the adv filter
gt; gt;gt; gt; unique
gt; gt;gt; gt; to a
gt; gt;gt; gt; new region but still get duplicate values for US and a 'salesperson'.
gt; gt;gt; gt; Tried
gt; gt;gt; gt; to trim to data, same result, brought into word and searched for a
gt; gt;gt; gt; space,
gt; gt;gt; gt; same problem. Ideas appreciated.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

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:
gt; OK, I want to filter unique records from column a to a new range and then
gt; filter the unique records from column b to a new range. When I do that I get
gt; two US and two Maidson. Is my office installation corrupted?
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;
gt;gt;These are the ones I got filtering
gt;gt;
gt;gt;US Maidson
gt;gt;US Davis
gt;gt;US Ali
gt;gt;US Lee
gt;gt;US Backel
gt;gt;US Smith
gt;gt;US Jackson
gt;gt;US Brown
gt;gt;
gt;gt;
gt;gt;
gt;gt;which one is a duplicate?
gt;gt;
gt;gt;
gt;gt;--
gt;gt;
gt;gt;Regards,
gt;gt;
gt;gt;Peo Sjoblom
gt;gt;
gt;gt;nwexcelsolutions.com
gt;gt;
gt;gt;
gt;gt;quot;headlyquot; gt; wrote in message
...
gt;gt;
gt;gt;gt;OK mr. microsoft can do no wrong, have a look at my data at
gt;gt;gt;
gt;gt;gt;www.headly.com/data.xls
gt;gt;gt;
gt;gt;gt;TIA
gt;gt;gt;
gt;gt;gt;quot;Peo Sjoblomquot; wrote:
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;gt;I doubt it is an error, I have never experienced an error so either you
gt;gt;gt;gt;must
gt;gt;gt;gt;apply it incorrectly or there are hidden characters, post a small sample
gt;gt;gt;gt;in
gt;gt;gt;gt;text like
gt;gt;gt;gt;
gt;gt;gt;gt;Header1 Header2 Header3
gt;gt;gt;gt;data data data etc
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;then post the criteria you are using
gt;gt;gt;gt;
gt;gt;gt;gt;--
gt;gt;gt;gt;
gt;gt;gt;gt;Regards,
gt;gt;gt;gt;
gt;gt;gt;gt;Peo Sjoblom
gt;gt;gt;gt;
gt;gt;gt;gt;nwexcelsolutions.com
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;quot;headlyquot; gt; wrote in message
...
gt;gt;gt;gt;
gt;gt;gt;gt;gt;Have a list of 1000 rows of data (countries). Use the adv filter
gt;gt;gt;gt;gt;unique
gt;gt;gt;gt;gt;to a
gt;gt;gt;gt;gt;new region but still get duplicate values for US and a 'salesperson'.
gt;gt;gt;gt;gt;Tried
gt;gt;gt;gt;gt;to trim to data, same result, brought into word and searched for a
gt;gt;gt;gt;gt;space,
gt;gt;gt;gt;gt;same problem. Ideas appreciated.
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;
gt;gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html