Line number of the last occurrence of a column

AppSheet AppSheet Q&A
1

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.

3X_2_2_2261ceb395686afb3c0b441960172fe96b8b7948.jpeg
3X_2_2_2261ceb395686afb3c0b441960172fe96b8b7948.jpeg474×502 26.4 KB

Thnk you so much

2

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks ?

How do I get the last row of this thing only? MAXROW( “My Table”, “_ROWNUMBER”, ([_THISROW].[Thing] = [Thing]) ) Replace My Table with the name of the table whose row you want; and Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID).

3

Thank you so much Steve.
I go try this

1 Like
4

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
5

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

[YourMaxrowVC].[_ROWNUMBER]

Or wrap the MAXROW with LOOKUP

1 Like
6

Thank you for you’r help Heru

1 Like
7

Try:

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

Replace table-name with the name of the table

1 Like
8

Thank you so much Steve it’s that!!

2 Likes