Help

Re: How to detect duplicates in a Cell

286 0
cancel
Showing results for 
Search instead for 
Did you mean: 
kennypurnomo
7 - App Architect
7 - App Architect

Hello, how can i detect any duplicates in a cell (in this case it’s “Accord”)

image

2 Replies 2

Formulas won’t work for this because they’re not robust enough. A script could do it, but it would need to be designed to know what exactly constitutes a duplicate. The other question is this: once you’ve detected duplicates, what do you want to do with them?

SergioCodes
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi @kennypurnomo,

It seems that the model is rolling up some data from another table, so one manual option is to use the “Dedupe” app on the other table to find and merge the records (if that is what you need to do).

As @Justin_Barrett mentions, the formulas may not be robust enough, although not sure if possible with regex.

Best
Sergio
https://devblocks.agency
If this reply fixed your problem, please mark it as a solution :white_check_mark: