Displaying unique entries from a filtered list

[theseandavis]

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

 

[Rob Hick]

check out this on Chip's website:
http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique

 

[theseandavis]

Thanks for the answer. I've seen that somewhere in my travels before,
and while its useful, I actually need this to be applicable AFTER a
list has been filtered for nonblank cells. Filesize is an issue so I am
trying to avoid a lot of unnecessary formulas resulting in blank cells.

I can make the above work however by starting it at the first displayed
row (in my case, d4597), as the data will be changing a lot overtime it
needs to be rather brainless.

 

[Gord Dibben]

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/xladvfilter01.html#FilterUR



Gord Dibben MS Excel MVP

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

 

[theseandavis]

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: