Formula that can capture duplicate in "Multi Contact List" Column, whether the contact name exist al

Abe B.

Hello SS Community,

Wondering if possible to find a formula to add in a helper column to capture when a contact name is repeated or duplicate in different rows, whether the contact name alone or if it comes with other names. I need it to know if a contact was assigned more than once within the same moth, meaning, if I have 10 rows, and the "Month" column has 10 entries for December, can I check the "Contact" column for name/s who were repeated within the range of December, and so on for different months and years combination?

Thanks in advance!

kowal

hi @Abe B.,

yes it is ;)

you can create helping column as a checkbox and inside you can use formula:

=IF(COUNTIF(Contact:Contact, =Contact@row) > 1, 1, 0)

Contact is the column where you check duplicates if there is a duplicate the helping column will be 1 otherwise it will be 0.

Hope it helps!

Abe B.

Thank you Kowal for your prompt answer!

The issue that I am encountering is with "Multi-Contact" column, where a contact name possibly exist as the only person, then in the below row/s the same contact is mentioned again but along with other name/s. The formula won't capture his/her name as a duplicate as it reads the entire value inside the cell.

For example, if Abe was assigned a task in one row, then Abe and John were assigned another task in the below row, I need to capture "Abe" as a duplicate in that helper column, by marking "Dup" or "1"…etc

Hope that helps understanding the issue here?