|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
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!