Find duplicates

Premium

Highlight the whole row when the customer ID appears more than once in A2:A6. In D2, write the rule with COUNTIF. Lock the whole range and the column in A2.

D2
ABCDEF
1Customer ID Name City Duplicate?
21001 Anne Holm Aarhus
31002 Jonas Berg Odense
41001 Anne Holm Aarhus
51003 Mette Lund Vejle
61004 Ali Khan Aalborg
7
8

Premium lesson

Unlock Conditional formatting and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:Drop-down lists and data validationCOUNTIF

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?