+ Reply to Thread
Results 1 to 3 of 3

Need help in comparing data in 2 sheets

  1. #1
    Registered User
    Join Date
    08-25-2008
    Location
    Chennai
    Posts
    2

    Question Need help in comparing data in 2 sheets

    Hi,

    I've got two excel sheets with each sheet having a single column of records. There are 15,000 records in the first sheet and nearly 13,000 records in the second sheet. The data is basically account numbers. I want to find out three things. First one is the account numbers which are common among the sheets. Secondly, I want the account numbers which are present in the first sheet but not in the second sheet. Finally, I want the account numbers which are present in the second sheet but not in the first sheet. Please let me know how to achieve this. My version of Excel is 2003.

    Thanks in advance!

    Regards,
    Babu

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    In Sheet1 B1 and copy down,

    =if(isnumber(match(A1, Sheet2!$B$1:$B$13000, 0)), "Both", "Unique")

    And then a symmetric formula on Sheet2.

  3. #3
    Registered User
    Join Date
    08-25-2008
    Location
    Chennai
    Posts
    2

    Smile

    Thanks a lot for your reply! You made my work easier.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Comparing data.
    By judygodchild218 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-24-2008, 02:23 PM
  2. sort data on multi sheets before creating mastersheet
    By brainfreez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2008, 02:02 PM
  3. Only certain sheets display data
    By quiksilver1804 in forum Excel General
    Replies: 1
    Last Post: 10-10-2007, 07:33 AM
  4. Collecting data from many sheets
    By smbutler in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-19-2007, 07:07 PM
  5. Filter data to other sheets
    By pauliano in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-27-2006, 04:51 AM

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