How to detect duplicates in a Cell

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

image

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?

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:

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