Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying unique entries from a filtered list
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying unique entries from a filtered list
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying unique entries from a filtered list
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying unique entries from a filtered list
DataFilterAdvanced 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, 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying unique entries from a filtered list
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: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
list unique values in a column | Excel Worksheet Functions | |||
Comparing Entries to a list | Excel Worksheet Functions | |||
counting unique entries in a list | Excel Discussion (Misc queries) | |||
Define a range containing the first 10 rows of a filtered list | Excel Worksheet Functions | |||
Can I compare 2 lists to combine duplicate entries in new list? | Excel Worksheet Functions |