Row number of last cell with value in column?

[afroveo]

Given a column with the cell values:

For given cell value, what formula will return the row number of the last cell with given value in the same column?

[mikekaganski]

Try MAXIFS:

=MAXIFS(ROW(A:A);A:A;<PUT_CELL_VALUE_HERE>)

[afroveo]

perfect, thank you!