This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Find the last data in list with specified criteria

Posted on 08-19-2024 03:37 AM
Chris_w
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

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

Solved Solved
0 2 115
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
TeeSee1
Gold 4
Gold 4
Reply posted on --/--/---- --:-- AM

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

 

View solution in original post

Jump to Solution
2 REPLIES 2
Top Labels in this Space