Extract Unique Values from Filtered List

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

Here is a sample workbook.

Thank you.

But I think I failed to fully explain exactly what I'm after. Let me explain further...

I want the list of VISIBLE counties from the auto-filtered list to appear on the original tab (either above or below the visible filtered data range) for quick reference so that I can see at a glance what counties' data is displayed. I'm not looking for just a simple listing of visible counties by itself, but a listing of visible counties that updates as the auto-filtered list selection criteria changes (I often add/subtract counties from the filtered list as I'm working). I was attempting to accomplish it with a formula but haven't been able to find a formula that works like SUMPRODUCT, SUBTOTAL, or INDEX. The point it for it to update the summary list as the autofilter criteria is changed.

Does that help?

Ken

Originally Posted by Bo_Ry

Not sure this is what you want.

This is EXACTLY what I wanted! Amazing!

Thank you very kindly!!!!!


Ken