Create a view based on duplicates

[Dalene_Rovensti]

Hi all, I'm stuck as to what to do here. Hoping someone can help. I THINK a formula should be able to do this? Essentially I want to create a view that shows me only the records that have a zip code that matches a zip code of another record. I was playing around with the DeDupe app, but that merges records, which isn't what I want. I want to keep the records, but I want a view that lets me easily view where the duplicates are. Screenshot attached to help communicate what I mean. Thanks! 

[Sho]

hi,

How about using this extension?

Dedupe Extension | Airtable Support

[TheTimeSavingCo · Accepted solution]

Try:
1. Create a new table called "Zip codes"
2. Create a linked field to "Zip codes" from your current table
3. Copy all the values form the "Zip" column and paste it into the linked field
4. In the "Zip Codes" table, create a "Count" field, thus giving you the number of records that have that zip code
5. In your original table created a lookup field to display the "Count" field you just created
6. Create a view that only displays records that have a lookup field value >1

This should do what you're looking for I think

[Dalene_Rovensti]

Yes! I never would have thought to do it this way, but I think it should work—thank you!!

[Dalene_Rovensti]

No, I mentioned above I had already looked into that extension, but I don't want to merge the records, only identify them.