Data>Filter>Advanced Filter

Check "unique records only" and "copy to another location".

See Debra Dalgleish's site for full instructions.

http://www.contextures.on.ca/xladvfi....html#FilterUR



Gord Dibben MS Excel MVP


On 26 Apr 2006 10:07:28 -0700, theseandavis@gmail.com wrote:

>Hello,
>
>I'm working with a large database (5400 rows by 15 columns) of data,
>some text. I need to be able to display only unique entries after a
>list has been filtered for nonblanks.
>
>Eg. I filter a list and it gives me:
>Mechanic
>Mechanic
>Interior Maintenance
>Mechanic
>Interior Maintenance
>Janitor
>Plumber
>
>I want to be able to create a list of the unique positions after the
>filter, which will say
>
>Mechanic
>Interior Maintenance
>Janitor
>Plumber
>
>Thanks so much,
>S Davis

Gord Dibben MS Excel MVP