+ Reply to Thread
Results 1 to 2 of 2

Compare and highlight column data across two worksheets

  1. #1
    Registered User
    Join Date
    03-26-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Compare and highlight column data across two worksheets

    Guys,

    New User Here... I am at your doorstep because I need some quick help.

    I have two worksheets in a single file. Each of these worksheets contains a column of numbers that both represent invoice numbers.

    What I am trying to accomplish is to highlight numbers if they exist on both lists. THE HIGHLIGHT ONLY NEEDS TO HAPPEN ON 1 OF THE LISTS. It does not have to be a graphic highlight... It could be another column called 'On Both Lists" with a possible YES/NO answer. Each list has about 5000 lines so creating a formula or automated process is critical.

    Note: each individual list can have duplicate invoice numbers (That is correct in the data). What I need to know is if a number exists on both lists.

    PLEASE HELP AND THANKS IN ADVANCE FOR YOUR TIME AND SUPPOER.

    Brian
    Last edited by bgontarski; 03-26-2012 at 10:29 AM.

  2. #2
    Registered User
    Join Date
    03-26-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: Compare and highlight column data across two worksheets

    Let's say both lists are in Column A of 'sheet 1' and 'sheet 2', have a column label in A1 and data begins in A2.

    In cell b2 of sheet 1, put in the formula =countif(sheet2!A:A,a2). Then fill down. That will tell you how many times the invoice number in the adjacent cell in sheet 1 appears in the list of invoice numbers in sheet 2. Obviously, anything above zero means it appears on the other list.

+ 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