A readings log is ordered oldest to newest. Put its last three entries beside the main table so someone can see the recent values without scrolling.
Take from the end of the data range
Use A2:A6 for R-01 through R-05 and B2:B6 for readings 1 through 5. Leave a three-by-two area clear and enter:
=TAKE(A2:B6,-3)The output starts with R-03 and ends with R-05. The order is the same as the source.

Illustrated tail selection. Use a negative row count to take from the end.
Check the first and last entry after appending
Add R-06 and its reading on row 7. The existing formula still ends at R-05. Extend the range to A2:B7 and confirm the result runs from R-04 to R-06. A growing source reference can avoid manual updates if your editor supports it.

Illustrated append check. A fixed source range only includes the rows it names.
If the log is sorted by ID or value rather than time, check the order before calling the output “latest.”



