How to catch duplicate data using formulas or premium apps?

Julius Benn Sabeniano

Hi, Good day!

I need help in catching this duplicate data with the same Service Type and Last Name but the First Name is different because the first one has middle initial. Can this be caught by sort of using formula or premium apps like datamesh? Anyone have a great mind or idea how to make a new column and formulas then labeled them as "Duplicate"?.

Thanks in advanced!

@Paul Newcome

@Andrée Starå

Paul Newcome

Same service type and last name would be...

=IF(COUNTIFS([Service Type]:[Service Type], [Service Type]@row, [Last Name]:[Last Name], [Last Name]@row) > 1, "Duplicate")

Paul Newcome

Same service type and last name would be...

=IF(COUNTIFS([Service Type]:[Service Type], [Service Type]@row, [Last Name]:[Last Name], [Last Name]@row) > 1, "Duplicate")