Find the last "TRUE" in a range returning result tells me the row number where it is

[nenadmail]

In range (Lj9:Lj5000) there are a few occurances of "TRUE"
I need the formula to tell me in which ROW NUMBER is the last "TRUE" occurance is found?

The result needs to be in cell (Lj5). I'll put the formula there. I just don't know how to write out the formula?

Please help! Thanks!
- Nenad

[benishiryo]

hi Nenad, does this work for you?
=LOOKUP(2,1/(LJ9:LJ5000=TRUE),ROW(LJ9:LJ5000))

[nenadmail]

Perfect!.. thanks a lot..

P.S. I just changed your "," commas into ";" colons... for my computer to accept it.

[Jakobshavn]

=lookup(2,1/(lj9:lj5000=true),row(lj9:lj5000))