Finding duplicate name and date of birth
Hi, I have a sheet with demographics date. I created a helper column to find if the combined name and date of birth are duplicates, it works when the name is exactly the same, but when there's a slight difference in the name, say one has a middle initial and the other doesn't have one, it won't be flagged as duplicate. This is my formula: =IF(COUNTIFS([Member Name]:[Member Name], [Member Name]@row, DOB:DOB, DOB@row) > 1, 1, 0)
How do I make it so it will still flag as duplicate? Thank you.
Help Article Resources
Check out the Formula Handbook template!