Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter
When we apply filters in a range of data we can see that there aren't
duplicates in the filter columns. Is it possible to get these itens from these filters? Where are these data? Are they in one array, collection or what? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter
You can use an advanced filter to extract the unique values from a
column in the table. There are some instructions he http://www.contextures.com/xladvfilter01.html#FilterUR cribeiro wrote: When we apply filters in a range of data we can see that there aren't duplicates in the filter columns. Is it possible to get these itens from these filters? Where are these data? Are they in one array, collection or what? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter
They are not accessible. You can get a list of uniques on the worksheet by
using the Advanced filter and selecting the Uniques checkbox. -- Regards, Tom Ogilvy cribeiro wrote in message ... When we apply filters in a range of data we can see that there aren't duplicates in the filter columns. Is it possible to get these itens from these filters? Where are these data? Are they in one array, collection or what? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter
I've tried this approach but it doesn't work for all situations.
I've used arrays and collections too. It would be an easy way to get these data if they were accessible by code in filtered data. Thank you all anyway. "cribeiro" wrote in message ... When we apply filters in a range of data we can see that there aren't duplicates in the filter columns. Is it possible to get these itens from these filters? Where are these data? Are they in one array, collection or what? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |