Hi,
I have more than 2000 emails in a list in Excel 2003. Question: how do I do conditional formatting for duplicated emails? I tried to use COUNTIF but didn't work.
Any direction would be greatly appreciated.
Thank you!!
Hi,
I have more than 2000 emails in a list in Excel 2003. Question: how do I do conditional formatting for duplicated emails? I tried to use COUNTIF but didn't work.
Any direction would be greatly appreciated.
Thank you!!
Assuming your email addresses are in column A starting with A2, select all the cells with the addresses in (from A2 onwards), then bring up the Conditional Formatting dialogue box and click Formula Is rather than Cell Value Is, and enter this formula:
=COUNTIF($A$2:$A2,A2)>1
Then click on the Format button, then the Patterns tab to choose your colour, then OK your way out. The CF will automatically be applied to all the cells, and will highlight any duplicates (but not the first one).
Hope this helps.
Pete
Thanks Pete. It worked really well.
Now if I'm checking duplicates between 2 worksheets, what should the COUNTIF formula be and should I select all the cells that contain email addresses in both worksheets?
For example,
=COUNTIF(Sheet1!$A$2:$A$112,Sheet2!A2)>1
Please correct my formula. Thank you so much for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks