Great one ! Thank you !

Vlado

"Bob Phillips" wrote:

=MAX(INDEX((A1:A10=100)*ROW(A1:A10),0))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Vlado Sveda" wrote in message
...
Problem is to find max Row() number for a value in column. Lets imagine
that
you have column like this:
A1: 1
A2: 2
A3: 100
A4: 1
A5: 1
A6: 100
A7: 3

What I need is to get max Row() for value (100 in this example) without
using VBA. (So in my example it'll return 6.)

Thanks to all in advance !

Vlado