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?