Find records in a field NOT unique

[Tom_David]

One of my fields has a copy of a record that should not be there. Is there an operator or formula that will find the two records which are NOT unique?

I did a simple search for 'copy' - that did not work. Any other suggestions are welcome.

Thx.

[Soly]

Hi @Tom_David , 

Are you saying that there is a duplicate record in your field and that you want to find it ?

If your table is not too big, a quick method is to sort your data from the specific field. This will arrange your records in order.

Then group your sorted data, by using the same field again.

Now, the group that has more than one item is your duplicate.

I hope that helps. Let me know

[Tom_David]

Thank you. I did find the record - it was an empty record at the bottom of the field (amateur mistake).

[Tom_David]

So, now I realize the problem was that there were more total records than 'unique' records (1 more) in the table so I 'assumed' there was a duplicate. Actually, it was an empty record; not a duplicate.

[Alexey_Gusev]

Hi,
Yes, sort is good to see if your data has problems, usually problem records sorted at the top or bottom.
Second possible way to find duplicates - trying to turn field into single-select, but don't save. Duplicates will appear at the top of list. Note that primary field can't be single select, so you need to duplicate at first (removing copied field at the end)

Third way - use Deduper extension or script from examples
Fourth - Link to new table, copy-paste field into linked, switch to new table, add Count field.

According to table size and the number of duplicates, each can be in use.

[Tom_David]

Good options for future use. Thank you.