Error using Advanced Filter Unique Records

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



"headly" <[email protected]> wrote in message
news:[email protected]...
> 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.

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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.
>>
>>
>>

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > 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.
> >>
> >>
> >>
>
>
>

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" <[email protected]> wrote in message
>>news:[email protected]...
>>
>>>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" <[email protected]> wrote in message
>>>>news:[email protected]...
>>>>
>>>>>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