Help

Highlight Duplicates in a Column

3327 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Brandi_Macouzet
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello, we have been researching and looking into different formulas that would allow us to highlight duplicates. We are looking to add a formula like this How to Highlight Duplicates in Google Sheets but for AirTable. However, we have yet to add or find any successful formulas that will highlight any duplicates automatically if they are added. We are looking for an expert to help create this functionality in every table that we have. So that we can add this to all of our tables.

4 Replies 4

Hi Brandi, have you tried Airtable’s Dedupe app? https://support.airtable.com/hc/en-us/articles/360008332253-Dedupe-app

You have to have a pro account though. Happy to help you further with this. Just DM or send an email to rupert.hoffschmidt@gmail.com

Brandi_Macouzet
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey @Rupert_Hoffschmidt, thanks for sharing that app we are aware of it. :slightly_smiling_face:

Yulia_Lukashuk
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey Brandi! Check out Heep :eyes:

You can find there an awesome expert for your project. It`s possible to post it & get matched with a handpicked expert in 48H or you can just message the one you would love to work with directly.

Hope you `ll find it useful:)

Hey Brandi,

Not sure if you’ve found anyone to help with this or not. It would be nice to see highlighted duplicates like in Sheets and Excel!

We have a Unique Arrays function in our On2Air Actions app. It searches 1 or multiple fields for unique data and stores the unique values in another field. This would be your “highlighted” field and is useful for filtering out duplicates.

The On2Air Actions app also includes an additional 60+ features that enhance your data in Airtable.

Features like creating Google Docs automatically with Airtable data, default field values, financial calculations, comparing field data, Google Sheets record and table sync, and more. You can see the list below.

Option 2:

The On2Air Amplify app has a Duplicates feature. The updated version of Amplify should be available in the marketplace this week.

2021-11-14_02h36_35

Hope this helps!

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable