Line number of the last occurrence of a column

Hello,
I’m looking for a formula to find the number of the last row of a value occurrence in a column.
Concretely here is an example with the expected line number in yellow.

Thnk you so much

0 7 415
7 REPLIES 7

Steve
Participant V

Thank you so much Steve.
I go try this

Steve
I tried the formula however I do not understand because it does not show me the line number.
I feel like she’s showing me the key.
Furthermore, when I save the formula, the cell type automatically changes to Ref, I don’t understand why.

thank you so much

You might be able to find the row number dereferencing from that Maxrow VC:

[YourMaxrowVC].[_ROWNUMBER]

Or wrap the MAXROW with LOOKUP

Thank you for you’r help Heru

Try:

(
  [_ROWNUMBER]
  = MAX(
    SELECT(
      table-name[_ROWNUMBER],
      ([_THISROW].[Number] = [Number])
    )
  )
)

Replace table-name with the name of the table

Thank you so much Steve it’s that!!

Top Labels in this Space