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

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.

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?

IF(Number > 1, "DUPLICATE", "NOT DUPLICATE")

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 :slight_smile:

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?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.