| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract filter items from Drop-Down Automatic Filter
Hi. I would like to ask if it is possible to extract individual items from Drop-Down Automatic filter and how (I am total begginer). I have a very long list (+50.000) of values in column and I would like to get nonredundant subset. I wrote a Sub() that compares every item in the column against all the other and deletes those that are the same. But the program is running for ages (2 days :-() Then it dawned on me that the non-redundant list is showed in those Filter Drop-Downs. But I have no clue how to copy it from there. I would be really greatful for any help. -- karpatov ------------------------------------------------------------------------ karpatov's Profile: http://www.excelforum.com/member.php...o&userid=31946 View this thread: http://www.excelforum.com/showthread...hreadid=516672 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Extract filter items from Drop-Down Automatic Filter
You could use data|filter|advanced filter and check that unique records only.
Debra Dalgleish has some instructions with pictures: http://www.contextures.com/xladvfilter01.html#FilterUR karpatov wrote: Hi. I would like to ask if it is possible to extract individual items from Drop-Down Automatic filter and how (I am total begginer). I have a very long list (+50.000) of values in column and I would like to get nonredundant subset. I wrote a Sub() that compares every item in the column against all the other and deletes those that are the same. But the program is running for ages (2 days :-() Then it dawned on me that the non-redundant list is showed in those Filter Drop-Downs. But I have no clue how to copy it from there. I would be really greatful for any help. -- karpatov ------------------------------------------------------------------------ karpatov's Profile: http://www.excelforum.com/member.php...o&userid=31946 View this thread: http://www.excelforum.com/showthread...hreadid=516672 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print Items in Drop Down Filter List | Excel Discussion (Misc queries) | |||
| pivot table - drop down filter box has 10% of items out of order | Excel Discussion (Misc queries) | |||
| Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
| Excel Auto Filter will not show all items in the drop down - why? | Excel Discussion (Misc queries) | |||
| How do I filter for items that end in % | Excel Discussion (Misc queries) | |||
Linear Mode
