Displaying unique entries from a filtered list

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

I'm afraid that doesn't work too well either.

I do need something quite hands off. This is a model for a client.
Seperate worksheets have been setup that autofilter out irrelvant
entries based off a base datapile of 5400 entries. Each sheet displays
certain values, and I want to be able to summarize at the bottom of the
page FROM the automatically filtered list. Every few weeks a new base
data pile will be put in and everything will change, so the approach
needs to be formulaic. Im thinking it may not be possible, but here's
hoping :crosses fingers: