Hi,

I have a simple spreadsheet that was populated by importing ascii data.
Everything looks normal, but when I attempt to use advance filter for unique
records only, it has no effect. Can anyone think of any reason why this
shouldn't work? It's a simple thing, but very annoying. I'm using excel
2002, SP3.

TIA,

Jim

--
"If you carve yourself to suit everybody, you'll soon whittle yourself away"

Are you filtering on a single column?

Are you sure it's not working? Maybe there's a subtle difference
(trailing/leading/multiple embedded spaces???)

Jim wrote:
>
> Hi,
>
> I have a simple spreadsheet that was populated by importing ascii data.
> Everything looks normal, but when I attempt to use advance filter for unique
> records only, it has no effect. Can anyone think of any reason why this
> shouldn't work? It's a simple thing, but very annoying. I'm using excel
> 2002, SP3.
>
> TIA,
>
> Jim
>
> --
> "If you carve yourself to suit everybody, you'll soon whittle yourself away"

--

Dave Peterson

Hi Pete,

yes, I'm filtering on a single column. And there sure doesn't APPEAR to be
any subtle difference; is there a way for me to check those items you've
mentioned?

thanks

Jim

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:474CC5D0.AD2BF0B@verizonXSPAM.net...
> Are you filtering on a single column?
>
> Are you sure it's not working? Maybe there's a subtle difference
> (trailing/leading/multiple embedded spaces???)
>
> Jim wrote:
>>
>> Hi,
>>
>> I have a simple spreadsheet that was populated by importing ascii data.
>> Everything looks normal, but when I attempt to use advance filter for
>> unique
>> records only, it has no effect. Can anyone think of any reason why this
>> shouldn't work? It's a simple thing, but very annoying. I'm using excel
>> 2002, SP3.
>>
>> TIA,
>>
>> Jim
>>
>> --
>> "If you carve yourself to suit everybody, you'll soon whittle yourself
>> away"
>
> --
>
> Dave Peterson

Jim

What type of data do you have?

Text? Numeric? Dates?

To look for extra spaces try =LEN(cellref) in an unused column and copy down.

Or =ISNUMBER(cellref) and copy down.


Gord Dibben MS Excel MVP

On Tue, 27 Nov 2007 23:36:47 -0500, "Jim" <lakerfan426@yahoo.com> wrote:

>Hi Pete,
>
>yes, I'm filtering on a single column. And there sure doesn't APPEAR to be
>any subtle difference; is there a way for me to check those items you've
>mentioned?
>
>thanks
>
>Jim
>
>"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
>news:474CC5D0.AD2BF0B@verizonXSPAM.net...
>> Are you filtering on a single column?
>>
>> Are you sure it's not working? Maybe there's a subtle difference
>> (trailing/leading/multiple embedded spaces???)
>>
>> Jim wrote:
>>>
>>> Hi,
>>>
>>> I have a simple spreadsheet that was populated by importing ascii data.
>>> Everything looks normal, but when I attempt to use advance filter for
>>> unique
>>> records only, it has no effect. Can anyone think of any reason why this
>>> shouldn't work? It's a simple thing, but very annoying. I'm using excel
>>> 2002, SP3.
>>>
>>> TIA,
>>>
>>> Jim
>>>
>>> --
>>> "If you carve yourself to suit everybody, you'll soon whittle yourself
>>> away"
>>
>> --
>>
>> Dave Peterson
>

If you filter in place, you'll be able to pick out two cells that look the same
to you, but show up as unique entries (just by eyeballing the visible cells).

Pick out a couple of cells (say A4 and A887) and in an empty cell, put:
=a4=a887
This will come back True if they match. False if they don't.

You can use:
=len(a4)&"--"&len(a887)
to see if the length's differ.

and
=trim(a4)=trim(a887)
to see if trimming any spaces would help.

Chip Pearson has a very nice addin that will help determine what is in each
cell:
http://www.cpearson.com/excel/CellView.aspx

Jim wrote:
>
> Hi Pete,
>
> yes, I'm filtering on a single column. And there sure doesn't APPEAR to be
> any subtle difference; is there a way for me to check those items you've
> mentioned?
>
> thanks
>
> Jim
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:474CC5D0.AD2BF0B@verizonXSPAM.net...
> > Are you filtering on a single column?
> >
> > Are you sure it's not working? Maybe there's a subtle difference
> > (trailing/leading/multiple embedded spaces???)
> >
> > Jim wrote:
> >>
> >> Hi,
> >>
> >> I have a simple spreadsheet that was populated by importing ascii data.
> >> Everything looks normal, but when I attempt to use advance filter for
> >> unique
> >> records only, it has no effect. Can anyone think of any reason why this
> >> shouldn't work? It's a simple thing, but very annoying. I'm using excel
> >> 2002, SP3.
> >>
> >> TIA,
> >>
> >> Jim
> >>
> >> --
> >> "If you carve yourself to suit everybody, you'll soon whittle yourself
> >> away"
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

Dave and Gord,

thanks for the tips...problem solved. There were indeed some characters in
there that I couldn't see that were making the difference. Thanks again.

Jim

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:474D5CA8.F31DA54D@verizonXSPAM.net...
> If you filter in place, you'll be able to pick out two cells that look the
> same
> to you, but show up as unique entries (just by eyeballing the visible
> cells).
>
> Pick out a couple of cells (say A4 and A887) and in an empty cell, put:
> =a4=a887
> This will come back True if they match. False if they don't.
>
> You can use:
> =len(a4)&"--"&len(a887)
> to see if the length's differ.
>
> and
> =trim(a4)=trim(a887)
> to see if trimming any spaces would help.
>
> Chip Pearson has a very nice addin that will help determine what is in
> each
> cell:
> http://www.cpearson.com/excel/CellView.aspx
>
> Jim wrote:
>>
>> Hi Pete,
>>
>> yes, I'm filtering on a single column. And there sure doesn't APPEAR to
>> be
>> any subtle difference; is there a way for me to check those items you've
>> mentioned?
>>
>> thanks
>>
>> Jim
>>
>> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
>> news:474CC5D0.AD2BF0B@verizonXSPAM.net...
>> > Are you filtering on a single column?
>> >
>> > Are you sure it's not working? Maybe there's a subtle difference
>> > (trailing/leading/multiple embedded spaces???)
>> >
>> > Jim wrote:
>> >>
>> >> Hi,
>> >>
>> >> I have a simple spreadsheet that was populated by importing ascii
>> >> data.
>> >> Everything looks normal, but when I attempt to use advance filter for
>> >> unique
>> >> records only, it has no effect. Can anyone think of any reason why
>> >> this
>> >> shouldn't work? It's a simple thing, but very annoying. I'm using
>> >> excel
>> >> 2002, SP3.
>> >>
>> >> TIA,
>> >>
>> >> Jim
>> >>
>> >> --
>> >> "If you carve yourself to suit everybody, you'll soon whittle yourself
>> >> away"
>> >
>> > --
>> >
>> > Dave Peterson
>
> --
>
> Dave Peterson