+ Reply to Thread
Results 1 to 3 of 3

Email List Duplilcates in Excel 2003

  1. #1
    Registered User
    Join Date
    05-15-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    Email List Duplilcates in Excel 2003

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

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Email List Duplilcates in Excel 2003

    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

  3. #3
    Registered User
    Join Date
    05-15-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Email List Duplilcates in Excel 2003

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1