When importing data, I can choose which fields to check on for duplicates. The base functionality will flag a duplicate if any of the fields are matched e.g. Firstname OR LastName OR Phone. I would like to only flag a dupe if there is a match on all the criteria e.g. Firstname AND LastName AND Phone. Is there any way to do this, or any 3rd party products that support this? I have searched but to no avail.
create a custom field that concatenates (with workflows - calculated fields) the three fields into one. Do the same thing on the importing data (via Excel formula, for example). Now you can use that big field to check for duplicates.