I am using the autofilter and cannot figure out a way to do this...
In Column A4:A500, I have 400+ rows with 3 distinct names in the
column; "A","B","C"...
When I filter this column by "A" I would like cell A2 to tell me that
name; "A". If by "B" then "B" etc... If it is not filtered then tell me
"All".

I then will use this name on another sheet & cell in the workbook.


Any help is appreciated!

Hans