I have a simple sheet with 3 columns.
Computer
Status
TimeStamp
I would like to create a slice to get all the computer and status but only for the latest timestamp.
Right now my data looks like :
Computer1, Online, 20220101
Computer1, Online, 20220102
Computer1, Online, 20220103
Computer2, Online, 20220101
Computer2, Online, 20220102
Computer2, Online, 20220103
My slice should return only :
Computer1, Online, 20220103
Computer2, Online, 20220103
The timestamp column is a valid datetime format. (but i simplified for visibility)
Thanks
What if the data is not in the correct order / sorted ?
Sorry for my hyperbrief original reply. I didn't think the linked technique necessarily applied directly, but could be adapted. As @MultiTech, already noted separately, you can sort rows before grabbing the last one (or, sort descending and grab the first one).
I'm more partial to the
Index(
OrderBy(
Table[ID],
[Order_Column]
),
Count(Table[ID])
)
way of getting the last of something (^_^)
Here's one that I just put in place:
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |