Help

Identify Duplicate Values in a field

2178 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Hannah_Henry
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m looking to write a formula that notifies me if there are duplicates of a certain field. There are other unique values in the spreadsheet, so I’m not looking to merge or delete them, but I want to be notified if a certain cell is not unique. I do this in Excel with:

=COUNTIF($B$2:$B2, B2)>1

Is there any manner to do this in AirTable? From what I’m seeing, lookup and rollup options that have been suggested in the community require an additional table and I’m looking to do this from the same table.

Thanks

2 Replies 2
BobDigital
5 - Automation Enthusiast
5 - Automation Enthusiast

Agreed it should be avail in the table but the dedupe block is pretty good. https://support.airtable.com/hc/en-us/articles/360008332253-Dedupe-block

It’s only useful if you want to remove the duplicates as you cannot access the list of duplicates outside of the Dedupe block.