Re: Make a list that excludes duplicates
- From: "Phil Osman" <PhilOsman@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 16 Jun 2005 21:08:14 -0700
Thanks Dave. I ended up setting the advanced filter up as a Macro, which
worked fine.
--
http://www.redbrick.dcu.ie/~pele
"Dave Peterson" wrote:
> You could use a helper column to extract the first portion of the cell (assuming
> that AAA 1 is in one cell).
>
> =LEFT(A1,SEARCH(" ",A1&" ")-1)
> (and copy down)
>
> Then you could use Data|Filter|Advanced filter to get that unique list.
>
> Debra Dalgleish has detailed instructions at:
> http://www.contextures.com/xladvfilter01.html#FilterUR
>
> Phil Osman wrote:
> >
> > I have a listing that looks like this:
> >
> > AAA 1
> > AAA 2
> > AAA 3
> > BB 1
> > BB 2
> > BB 3
> > BB 4
> > C 1
> > DD 1
> > DD 2
> > Etc.....
> >
> > I want another list to link to this but only pick up the unique text entries
> > excluding the numbers, so the result should be:
> > AAA
> > BB
> > C
> > DD
> > Etc.....
> >
> > If there have to be spaces in this second list then so be it, but I would
> > love to find a solution.
>
> --
>
> Dave Peterson
>
.
- References:
- Make a list that excludes duplicates
- From: Phil Osman
- Re: Make a list that excludes duplicates
- From: Dave Peterson
- Make a list that excludes duplicates
- Prev by Date: Re: I can't format 01/19/2004 to read January 19, 2004, please hel
- Next by Date: Re: Selecting cells that contain text in a specific format
- Previous by thread: Re: Make a list that excludes duplicates
- Next by thread: HELLLP!!!! This should be fairly simple I would think!
- Index(es):
Relevant Pages
|
