How do I flag duplicate addresses

J

JP

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
 
D

Debra

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Flag duplicate emails 1
How do I set focus (and select text) on a text box on a modeless userform? 0
Using Flags with Resource Percentages 0
Insert name and adress from a list in a word document 1
using duplicate function 19
How do I create a set of words that are flagged? 0
Have 4 email addresses Want to auto forward all in one of them 0
Remove duplicates in one column within a range of dates in another column 6

Top