Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter by unique values
I would like to build into the autofilter function a selection under the
custom options to "show rows where" and the drop down box would have "contains unique values". In other words, I want to autofilter by unique values. I know I can get unique values by advanced filter and a pivot table, but I want the ability to filter the list in place. Any ideas or other solutions? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter by unique values
Steve
You can use EasyFilter to do this if you want to filter on one column http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Steve@Michelin" wrote in message ... I would like to build into the autofilter function a selection under the custom options to "show rows where" and the drop down box would have "contains unique values". In other words, I want to autofilter by unique values. I know I can get unique values by advanced filter and a pivot table, but I want the ability to filter the list in place. Any ideas or other solutions? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter by unique values
"Steve@Michelin" skrev i melding
... (...) I know I can get unique values by advanced filter and a pivot table, but I want the ability to filter the list in place. Advanced filter DOES filter in place. Just select "filter in place" and the "unique records only" checkbox. HTH. Best wishes Harald |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unique Values, not Unique Records | Excel Discussion (Misc queries) | |||
Unique Records Count with AutoFilter | Excel Worksheet Functions | |||
AutoFilter and unique items | Excel Discussion (Misc queries) | |||
AutoFilter lists unique values | Excel Discussion (Misc queries) | |||
How do I search thr'o column and put unique values in differnt sheet and sum corresponding values in | Excel Programming |