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!