Duplicate values

sbentley

Hi,

I need a formula that removes duplicate data. The unique identifier would be email addresses. I read the best way to do this is to add a checkbox column for duplicates but I can't figure out the formula to automatically check the box if the email address already exists in the sheet. Please help!

James Keuning

Checkbox:

=(COUNTIF([YOUR COLUMN]:[YOUR COLUMN], [YOUR COLUMN]@row)) > 1

You can also do:

=IF(COUNTIF([YOUR COLUMN]:[YOUR COLUMN], [YOUR COLUMN]@row) > 1, 1, 0)

It's not a checkbox, it puts a 1 if the record is a duplicate

SoS | Dan Palenchar

Hi!

I made a video that shows how to do this. It will show you the formula as well as a way to automatically remove the duplicate data from the Sheet once it is recognized.

https://www.youtube.com/watch?v=i3DOqQXJXvk