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

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!

In article ,
"Bg" wrote:

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

I guess that should read...

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

In article ,
Domenic wrote:

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!

Domenic,
Works great...thnaks very much!
Bg

"Domenic" wrote in message
...
I guess that should read...

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

In article ,
Domenic wrote:

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!