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?

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?

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