I have a large table of records which all have a unique key but many of which are duplicated. They all have a date created field too. I would like to try to write a formula (I can try VBA but lack any knowledge or talent here) to add a note to the third column which I have labelled as "Action" which will either be 'Keep' or a 'date' to delete. based on identifying similar records via the Key and keeping the oldest whilst adding a date to delete to any more recent i.e
Please can anyone help?
Julian
KEY | Created | Action |
370596 | 03/05/2018 | Keep |
425128 | 03/05/2017 | Keep |
425128 | 16/09/2017 | 01/05/2020 |
425128 | 23/09/2017 | 01/05/2020 |
475521 | 07/05/2018 | Keep |
475521 | 01/10/2018 | 01/05/2020 |
475521 | 17/09/2019 | 01/05/2020 |
Please can anyone help?
Julian