Find duplicates based on multiple criteria

Bryan Zheng

Hello everyone,

I need some help with correct formula to find out duplicates. Is there a way to find duplicate records if case number, client's name, from date, and to date are the same? The first and last records are duplicate but how do I set up a correct formula? I currently only have case number and name columns in my formula but not dates.

Thanks,

Paul Newcome

Try something like this...

=IF(COUNTIFS([Case Number]:[Case Number], [Case Number]@row, [Client's Name]:[Client's Name], [Client's Name]@row, [From Date]:[From Date], [From Date]@row, [To Date]:[To Date], [To Date]@row) > 1, 1)

Paul Newcome

Try something like this...

=IF(COUNTIFS([Case Number]:[Case Number], [Case Number]@row, [Client's Name]:[Client's Name], [Client's Name]@row, [From Date]:[From Date], [From Date]@row, [To Date]:[To Date], [To Date]@row) > 1, 1)

Bryan Zheng

Hi Paul,

Thank you so much for help. It worked :)

Thanks,

Bryan

Paul Newcome

Happy to help. 👍️