I hope someone can assist? I have a table with 2500 rows relating to people who have a unique reference number. Some of these users are duplicated by reference number but have other fields in the table (start date in this case) which are not duplicates. I would like to have a formula to group the duplicates together and then mark them (via txt in a new column) if their start dates differ.
i.e in this example
I would like to indicate that 492495 has all different dates but 669250 has two matching dates.
Any help gratefully received.
i.e in this example
492495 | 09/10/2017 15:45 |
492495 | 26/02/2018 19:12 |
492495 | 01/03/2018 15:56 |
492495 | 05/04/2018 15:11 |
669250 | 09/05/2017 00:57 |
669250 | 15/04/2020 17:48 |
669250 | 15/04/2020 17:48 |
I would like to indicate that 492495 has all different dates but 669250 has two matching dates.
Any help gratefully received.