a filter question

Giganews Newsgroups
Subject: a filter question
Posted by:  hansjha…@yahoo.com (hansjha…@yahoo.com)
Date: 16 May 2006

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

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

Any help is appreciated!