+ Reply to Thread
Results 1 to 2 of 2

Find Duplicates on two worksheets

  1. #1
    Registered User
    Join Date
    09-30-2011
    Location
    somerset
    MS-Off Ver
    Excel 2003
    Posts
    1

    Find Duplicates on two worksheets

    Hi all hope someone can help, Im working with a large amount of data,

    Firstly i have one worksheet with two sheets, sheet1 and jeffo

    Secondly the data i need to compare is in column A on both sheets and consits of both numbers and letters i.e 027D-56-4070

    What i need to achive is to compare both sheets for duplicate entrys and to highlite the duplicate entrys in colum A of sheet1

    Any help would be appreciated

  2. #2
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: Find Duplicates on two worksheets

    If you just want the cells to be highlighted with a different format, you would need to use conditional formatting, with the following formula:

    =COUNTIF(jeffoa,A1)>0

    With 'jeffoa' being the name I have given to Jeffo!A:A (as you can't directly reference another sheet in conditional formatting).

    To name the range, highlight column A on the Jeffo sheet, then type whatever name you desire in the cell range box just above cell A1.

    Hope this helps, or at least makes sense!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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