Find duplicates based on multiple criteria
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,
Best Answer
-
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)
Answers
-
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)
-
Hi Paul,
Thank you so much for help. It worked :)
Thanks,
Bryan
-
Help Article Resources
Categories
Check out the Formula Handbook template!