Use MATCH to find the last position of a matching value.

earl_bennett

In the period column I have a MATCH formula to get the position of the matching value in Current Month.

=IFERROR(MATCH([Current Month]@row, June@row:May@row, 0), "")

In this case the value returned is 5.

How would I get the position of the last matching value, which would return 8?

Thank you!

Samuel Mueller

@earl_bennett I think would need a helper row that has the number 1-8 in the months. So june- 1, july- 2, etc.

Then you would need a formula such as

=MAX(COLLECT(june$1:january$1, june@row:january@row, [Current Month]@row))

Where June$1:January$1 is your helper row with the numbers 1 through 8.

You would not be able to make this a column formula

earl_bennett

Of course... Should have thought of that myself, thank you!