Filtered Cell Question

B

Bg

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
 
D

Domenic

To return the last text value in a filtered list, try...

=LOOKUP(2,1/SUBTOTAL(3,OFFSET(A2:A10,ROW(A2:A10)-ROW(A2),0,1)),A2:A10)

Hope this helps!
 
Top