Find records in a field NOT unique

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

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

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.

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.