Re: Error using Advanced Filter Unique Records

Giganews Newsgroups
Subject: Re: Error using Advanced Filter Unique Records
Posted by:  Peo Sjoblom (peo.sjobl…@nw^^excelsolutions.com)
Date: Mon, 8 May 2006

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" <head…@discussions.microsoft.com> wrote in message
news:2A85CBBB-EF38-4D4C-AD46-0B919FF605…@microsoft.com...
> 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.

Replies

In response to

Error using Advanced Filter Unique Records posted by headly on Mon, 8 May 2006