I have a worksheet with 8 columns and 600+ rows of data. I have filters
enabled for all the columns. Column "A" is for last names. When I filter the
names in column "A", I will get about 10-20 last names. I would like to have
formula in cell A-10 that will use the last name that was filtered in column
"A".
Is that possible?

Thanks
Bg