Google Sheets – Get Last Row Number of Repeated Value

google sheets

I have column like so

Mike
Fred
Mike
Andy
Mike

I want to return to me the last row number where the column = Mike. So in this case the output should be 5

I've think its combination of max filter row functions but need help on putting it together. Or maybe it could be done another way.

This is my best attempt so far:
= ROW (FILTER(A1:A, ROW(A1:A) =MAX( FILTER( ROW(A1:A) , ("Mike")))) )

Best Answer

=max(arrayformula(if(A1:A5="Mike", row(A1:A5), 0)))