How can I identify Duplicate entries across two sheets?
I have two sheets with overlapping information. I already have a formula that identifies duplicate clients within each sheet individually by returning a number for how many times in the sheet that client name shows up. The formula we use for this is =COUNTIFS([Name Helper]:[Name Helper], [Name Helper]@row)
Since the clients should not be located in both sheets, I am looking for a way to identify if a client is located in both sheets (IE if the client name is found in this sheet only, return value 1, if the client name is found in this sheet and the sister sheet, return value 2). I'd then resolve by moving/deleting the duplicate row. What formula can I use to identify to identify if the client is found in this sheet and in the sister sheet or just in this sheet?
Help Article Resources
Check out the Formula Handbook template!