Find the last data in list with specified criteria

[Chris_w]

How can I find the latest data in a list with specified criteria?
For example: Staff A has 5 pieces of data, 3 of which are salary data, and 2 are vacation data. I want to find the most recently entered data among the 3 pieces of salary data.

Thank you

[TeeSee1 · Accepted solution]

If you have a definitive field to order the rows by, you can do it using maxrow(). Or you can use _ROWNUMBER if the data entry order defines the 'latest' row.

https://support.google.com/appsheet/answer/10107920?sjid=6374875873367599606-AP

[Kurniawan-Haria]

Add a timestamp column and use select with max function to the column and add the salary column as criteria.