Forum Discussion
Filter, Then Sort, Then Select
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 Try this and let me know how it goes: The working file is attached below my signature.
3 Replies
Works like a charm, thank you AntrikshSharma
SearchKnowledge Try this and let me know how it goes: The working file is attached below my signature.
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!
