basenine 8/19/2018 6:15:24 AM
You should be able to do [COLUMN NAME]=[COLUMN NAME] in the view.
Navigate to the "Matching" section of a view in setup -->
Select "Custom formula" -->
[***COLUMN NAME] = [***COLUMN NAME]
The trouble you might find is if the data has been entered in differently in two different:
"Bert Simson" in one record and "Bert Simpson" in another...typo error nulls the "="
You could do a couple of different variants of the Match condition...maybe Phone number?
If you use a phone number, you might be able to use the formatting function built into the column first, so you've a better chance of the numbers matching