I'm looking to return a listing of unique values from an auto-filtered list.

I have a range of customer data (address, phone number, etc...) that I'm sorting by individual county. The list has 67,950 records (rows of data) with countless records falling in the same counties randomly throughout the list (there are a total of 83 counties overall). When I auto-filter the list to exclude counties whose data I don't want to see, the list is still huge (at any given time I may be looking at a couple of dozen counties in a filtered list), so I want to have a quick reference showing what counties are still visible.

All of my counties are listed in column "I" (I5:I67950).

This must be a tough one because I can't find a reference to this type of solution ANYWHERE!

Any ideas?


Ken