+4Hi 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!
Best answer by TheTimeSavingCo
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
+31Try:
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
+4Try:
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
Yes! I never would have thought to do it this way, but I think it should workâthank you!!
+4hi,
How about using this extension?
No, I mentioned above I had already looked into that extension, but I don't want to merge the records, only identify them.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.