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
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!!
User | Count |
---|---|
59 | |
25 | |
13 | |
12 | |
6 |