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

Thank you so much Steve.
I go try this :wink:

1 Like

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

1 Like

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

[YourMaxrowVC].[_ROWNUMBER]

Or wrap the MAXROW with LOOKUP

1 Like

Thank you for you’r help Heru

1 Like

Try:

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

Replace table-name with the name of the table

1 Like

Thank you so much Steve it’s that!! :partying_face:

2 Likes