Hi all,
Column A contains a bunch of IDs, L contains various times - I would like a lovely bit of code that chucks out a unique list of those ID's with the last associated time on another sheet).
Unfortunately I had a bit of code that would do this for me, but I've lost it.
Here is my example data
The results on sheet2 should look something like the following
with the times now in K instead of L
Thanks everyone
Column A contains a bunch of IDs, L contains various times - I would like a lovely bit of code that chucks out a unique list of those ID's with the last associated time on another sheet).
Unfortunately I had a bit of code that would do this for me, but I've lost it.
Here is my example data
1219 | 24/12/2021 17:00 | ||||||||||
1219 | 24/12/2021 17:15 | ||||||||||
1219 | 24/12/2021 19:30 | ||||||||||
1219 | 24/12/2021 20:00 | ||||||||||
1219 | 24/12/2021 22:00 | ||||||||||
1219 | 24/12/2021 22:15 | ||||||||||
1219 | 25/12/2021 00:30 | ||||||||||
932 | 24/12/2021 07:45 | ||||||||||
932 | 24/12/2021 08:15 | ||||||||||
932 | 24/12/2021 08:45 | ||||||||||
932 | 24/12/2021 09:45 | ||||||||||
932 | 24/12/2021 10:00 | ||||||||||
932 | 24/12/2021 13:30 | ||||||||||
932 | 24/12/2021 14:00 | ||||||||||
932 | 24/12/2021 15:00 | ||||||||||
932 | 24/12/2021 15:15 | ||||||||||
932 | 24/12/2021 17:30 | ||||||||||
916 | 24/12/2021 13:00 | ||||||||||
916 | 24/12/2021 14:30 | ||||||||||
916 | 24/12/2021 14:45 | ||||||||||
916 | 24/12/2021 16:45 | ||||||||||
916 | 24/12/2021 17:15 | ||||||||||
916 | 24/12/2021 19:15 | ||||||||||
916 | 24/12/2021 19:45 | ||||||||||
916 | 24/12/2021 22:00 | ||||||||||
916 | 24/12/2021 22:15 | ||||||||||
916 | 25/12/2021 00:30 | ||||||||||
542 | 24/12/2021 08:00 | ||||||||||
542 | 24/12/2021 09:00 | ||||||||||
542 | 24/12/2021 09:15 | ||||||||||
542 | 24/12/2021 11:15 | ||||||||||
542 | 24/12/2021 11:30 | ||||||||||
542 | 24/12/2021 12:39 | ||||||||||
542 | 24/12/2021 13:09 | ||||||||||
542 | 24/12/2021 14:15 | ||||||||||
542 | 24/12/2021 14:30 | ||||||||||
542 | 24/12/2021 15:30 | ||||||||||
542 | 24/12/2021 15:45 | ||||||||||
542 | 24/12/2021 16:45 | ||||||||||
The results on sheet2 should look something like the following
1219 | 25/12/2021 00:30 | |||||||||
932 | 24/12/2021 17:30 | |||||||||
916 | 25/12/2021 00:30 | |||||||||
542 | 24/12/2021 16:45 | |||||||||
with the times now in K instead of L
Thanks everyone