Skip to main content

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

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

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.

Reply


Terms & Conditions