Hi,
I have a long list of data to which I've applied the Advanced filter to show only unique records. I now want to use Autofilter to show subsets of that data, but when I click Autofilter, Excel removes the original Advanced filter criterion, i.e. I have hundreds of duplicate values again.
Is there a way of filtering only the unique records?
Thanks
Bookmarks