Row filter slice the latest timestamp

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

0 4 84
4 REPLIES 4

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:

MultiTech_0-1660760664963.png

 

Top Labels in this Space