Question

Hi team - I have an intake form that my workers are using that asks for their user email.

In the source sheet are some entries that I prefilled out - including some employees and their respective email. Employees that were prefilled in were not to use the intake form.

However, some of those employees decided to use the intake form now I have duplicate entries on the source sheet.

Question: how can I identify duplicates on my source data sheet?

I do not have the DataMesh app on my account.

Thanks,

Jeff

Michael Pappas · Accepted Answer

I would add another column, and use a COUNTIF function like =COUNTIF([Column 1]:[Column 1],[Column 1]@row). Convert it to a column formula. Then, Sort Rows..., Sort Item By COUNTIF Column, Sort Descending. The duplicates should be at the top of the column.