Vlado,

Array enter (enter using Ctrl-Shift-Enter)

=MAX(IF(A1:A7=100,ROW(A1:A7)))

HTH,
Bernie
MS Excel MVP

"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