Ask Your Question
0

row number of last cell with value in column?

asked 2020-06-15 14:16:32 +0200

afroveo gravatar image

Given a column with the cell values:

image description

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
2

answered 2020-06-15 14:21:50 +0200

Try MAXIFS:

=MAXIFS(ROW(A:A);A:A;<PUT_CELL_VALUE_HERE>)
edit flag offensive delete link more

Comments

perfect, thank you!

afroveo gravatar imageafroveo ( 2020-06-15 14:53:10 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-06-15 14:16:32 +0200

Seen: 124 times

Last updated: Jun 15 '20