Filter, Then Sort, Then Select

[SearchKnowledge]

Dear kind Sir/Madam,

Imagine a table with four colums, actually dont imagine, just look below.

Key	Date/Time	Remaining	NEW
6581	16/12/2020 05:34:33	-1
6581	19/12/2020 08:24:25	0,2
6581	19/12/2020 12:54:23	3,2	3,2
7892	21/12/2020 10:24:23	3
7892	24/12/2020 08:54:23	2	2

I would like to see the result like in the last column. So this new function I am looking for should first determine all the rows with the same "key". Then it should look at the corresponding "Date/Time" which date is the most recent (Can be an hour difference only). Then with the most recent date it should return the value from 'Remaining'. Resulting in a column like you can see in red.

I hope you are able to help me, thank you for the effort anyway.

Kind Regards.

[SearchKnowledge]

Works like a charm, thank you @AntrikshSharma 

[AntrikshSharma · Accepted solution]

@SearchKnowledge  Try this and let me know how it goes: The working file is attached below my signature.

[SearchKnowledge]

@AntrikshSharma Thank you for your fast reply and effort, awesome! I only work on the project once a week. But I will try to test it this week. I will let you know!