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?