Results 1 to 2 of 2

Thread: how to match data between 2 columns in excel

  1. #1
    Join Date
    Apr 2013
    Posts
    1

    how to match data between 2 columns in excel

    please guys,

    I have a problem and i need help urgently..

    I have 2 columns in one sheet withe the fallowing data:

    col1: contains a 7 digit numbers

    col2: contains "amount" also around 6 didgits

    The rows might reach 8000 rows

    for example:

    sheet1

    Col 1 col2

    1. 251401 100000
    2. 251403 50000
    3. 251404 2500
    4.
    5.

    Sheet 2:

    Col 1 col2

    1. 251404 2500
    2. 251403 50000
    3. 123 77777 <----- I need to get the rows that does not match
    4. 251401 100000
    .

    In Sheet 2 i have the same columns but less rows and not sorted with also the same data (matched) and some data that doesnt match.

    my problem is:
    i want Excel to search for the data in Sheet 2 in sheet 1 and match them.

    one if these solution if possible will satisfy me:

    1. even to sort the data to be against each other and the rest unmatched item to be at the end of the rows

    or


    2.or if not possible:
    to highlight the same data in sheet 1 with the same data in sheet 2 so i can cut them and paste them in another sheet and the remaining items will be my answer.

    -------------------------------------------

    Col 1 col2 col3 col4

    1. 251401 100000 251401 100000
    2. 251403 50000 251403 50000
    3. 251404 2500 251404 2500
    4. 123 77777




    Any Help would be highly appreciated ..

    Thanking you in advance

  2. #2
    Join Date
    Dec 2007
    Posts
    2,291

    Re: how to match data between 2 columns in excel

    Check the article on "Use Excel to compare two lists of data" from this link - http://office.microsoft.com/en-in/ex...001103915.aspx

Similar Threads

  1. [VBS] Change data in columns in CSV
    By Conus in forum Software Development
    Replies: 1
    Last Post: 30-04-2012, 10:48 PM
  2. How to divide two different columns data in Excel
    By Chini mao in forum Microsoft Project
    Replies: 1
    Last Post: 08-01-2012, 06:17 PM
  3. How to swap data between columns and rows in Excel
    By Rao's in forum Microsoft Project
    Replies: 1
    Last Post: 08-01-2012, 05:16 PM
  4. How to find percentage of columns data in Excel
    By Kungfu Pandey in forum Windows Software
    Replies: 2
    Last Post: 07-01-2012, 05:50 PM
  5. Macro to Add Columns in Excel
    By geokilla in forum Windows Software
    Replies: 3
    Last Post: 15-10-2009, 01:10 PM

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
  •  
Page generated in 1,638,480,073.88101 seconds with 17 queries