Formula to find last row in range that has the number 2 in it

[tonywatsonhelp]

Hi Everyone,
Thought this would be simple but I need help please.

Column BJ

contains lots of Number, many repeats, so "2" could appear in lots of rows,
what i want is a formula to tell me what the last row with the number "2" is?

please help if you can

Thanks

Tony

 

[Fluff]

For 365

=XMATCH(2,BJ1:BJ100,0,-1)

for any version

=LOOKUP(2,1/(BJ1:BJ100=2),ROW(BJ1:BJ100))

 

[tonywatsonhelp]

Thank you fluff,
this is great

 

[Alex Blakenburg]

Too slow, I wish I could figure out how delete the post from edit mode.

 

[Fluff]

You're welcome & thanks for the feedback.