How do I flag duplicate addresses

  • Thread starter Thread starter Guest
  • Start date Start date
Hi,
You could try conditional formatting.

I took this example from contextures.com:

Select range A2:A11
Choose Format|Conditional Formatting
From the first dropdown, choose Formula Is
Click to expand...
For the formula, enter
=COUNTIF($A$2:$A$11,A2)>1
Click the Format button.
Select a font colour for highlighting.
Click OK, click OK

When you delete a dupe, the formatting will disappear. When all the
formatting disappears, remove conditional formatting.


HTH,
JP
 
Thank you. That was very helpful.

Debra

JP said:
Hi,
You could try conditional formatting.

I took this example from contextures.com:

Select range A2:A11
Choose Format|Conditional Formatting
For the formula, enter
=COUNTIF($A$2:$A$11,A2)>1
Click the Format button.
Select a font colour for highlighting.
Click OK, click OK

When you delete a dupe, the formatting will disappear. When all the
formatting disappears, remove conditional formatting.


HTH,
JP
Click to expand...
 
Back
Top