Re: excel duplicates problem
From: Ken Wright (ken.wright_at_NOSPAMntlworld.com)
Date: 01/31/05
- Next message: GOL: "Charts"
- Previous message: Gibbie: "Re: Navigating"
- In reply to: Jason: "Re: excel duplicates problem"
- Next in thread: Ken Wright: "Re: excel duplicates problem"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 31 Jan 2005 21:58:08 -0000
Ahhhh - One you are filtering in place - is that what you meant to do? All
that does is hide the duplicates - You can filter to another range and it
will a list of unique values only.
What you are seeing as duplicates I would be 99% sure aren't. We see this
type of question a fair bit and it usually comes down to leading/trailing
spaces etc in some of the values that make them different in actuality but
visually look the same. Pick any two entries you think look the same and
then assuming they were in A3 and A4, in any other cell try =A3=A4 and see
if it is TRUE or FALSE. If FALSE then examine each record carefully.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Jason" <Jason@discussions.microsoft.com> wrote in message
news:3C4E7FA4-35D1-4B20-9FED-34360BD96298@microsoft.com...
> Thanks everyone....but i must be doing something else wrong. When I select
> the rows (which is all of them) and click"ok" nothing happens. The
numbers
> of the rows turn blue, but there are still some duplicate addresses (which
> are in column A). Did I miss something?
>
> thanks
>
> "Nick Hodge" wrote:
>
> > Jason
> >
> > Highlight the data in this box and then select the data in the range you
are
> > trying to filter
> >
> > --
> > HTH
> > Nick Hodge
> > Microsoft MVP - Excel
> > Southampton, England
> > nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
> >
> > "Jason" <Jason@discussions.microsoft.com> wrote in message
> > news:B76B3CCF-72BD-46B7-9FF1-F9443BC23D2C@microsoft.com...
> > > I'm trying to eliminate duplicates from an imported list and the
advanced
> > > step has me stuck. When I get to the advanced filter, there are some
word
> > > figures in the "list range". something like "$A$$660:$0$$" I click
"ok"
> > > and
> > > it comes up with an error. What am I doing wrong?
> > >
> > > thanks
> > > Jason
> >
> >
> >
- Next message: GOL: "Charts"
- Previous message: Gibbie: "Re: Navigating"
- In reply to: Jason: "Re: excel duplicates problem"
- Next in thread: Ken Wright: "Re: excel duplicates problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
