software

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 Davischeck out this on Chip's website:
www.cpearson.com/excel/duplic...tractingUniqueThanks 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.Datagt;Filtergt;Advanced Filter

Check quot;unique records onlyquot; and quot;copy to another locationquot;.

See Debra Dalgleish's site for full instructions.

www.contextures.on.ca/xladvfi....html#FilterUR
Gord Dibben MS Excel MVPOn 26 Apr 2006 10:07:28 -0700, wrote:

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