Dupe Check

Spot duplicate records in a customer list where the differences are a middle initial or a trailing space.

How to play

Scan a customer list for records that are the same person entered twice, where the only difference is a middle initial, a shortened name or a trailing space.

More in Excel

• Typing Speed Measure words per minute and accuracy on the vocabulary that fills an ordinary working day.
• Spot the Odd Cell Find the one cell in a spreadsheet whose value breaks the pattern of the column around it.
• Formula Audit Audit a column of formulas and find the row whose range or reference is wrong.