Looking for a formula that shows value of records are "duplicate" or "not duplicate"

Topic Labels: Formulas
1072 4
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi All,

I am looking for a formula that shows value of records are “duplicate” or “not duplicate”.

In Google Sheet, I use formula (=IF(COUNTIF(A:B,B1)>1,“duplicate”,“not duplicate”) but in Airtable, I can’t use same that formula.

Please help me, thanks All.

4 Replies 4

Hi there. Based on your formula, it seems like every record with a number bigger than 1 is a duplicate while the rest is not. So maybe just like this?


In Airtable, you’re not checking for entire columns, but for every record (similar to row in Excel). So with the formula above, you’re basically saying: If the Number field in this record (row) is above 1, it’s a duplicate, otherwise it’s not.

Let me know if this was what you were looking for :slightly_smiling_face:

Thank you for answering me but I don’t understand your idea. Please get your formula in airtable, it did not working.

Does this help?



The author has a completely different formula