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
I've think its combination of
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")))) )