I would like to locate duplicates in my sheet using the name column and email column. Just starting with the name column gets me nowhere. I keep getting #UNPARSEABLE. I am using =IF(COUNTIF(Client Name:Client Name, Client Name@row) > 1, 1) in a separate column.
Eventually I would like to include the email column which has two entries for an automation but I need to exclude one of the email addresses.
What am I doing wrong in the first formula and how do I incorporate the second part?
Thank you!