Finding duplicate values
You can find all records in which one or more fields contain duplicate values (for example, the same company name in the Company field in multiple records).
To find all duplicate records:
1.
See Making a find request.
2.
 
! in the Company field finds all records that contain the same company name in the Company field. (ABC Company and DEF Ltd. when duplicate values exist for these companies in multiple records)
!ABC in the Company field finds all records containing ABC Company when duplicate values exist for this company in multiple records
Notes
 •
One field by itself is often not sufficient to determine the uniqueness of a record. If several fields taken together determine uniqueness, you can create a calculation field (returning a text result) that concatenates the values of several fields, and then perform a find for duplicate records on that field. For example, you could use the formula First Name & Last Name & Phone Number to concatenate three fields. See Defining calculation fields.
 •
 •
 •
 •
To delete the found set of duplicate records, see Deleting records.
 •
Related topics 
Replacing the contents of a field
Defining automatic data entry
Defining calculation fields
Working with related tables and files
Summarizing data in portals