Results 1 to 5 of 5

Matching numbers in two columns

This is a discussion on Matching numbers in two columns within the Excel Questions forums, part of the Question Forums category; I am experiencing some difficulties matching numbers in two columns in Excel. My project requires me to figue out whether ...

  1. #1
    New Member
    Join Date
    May 2002
    Location
    Connecticut
    Posts
    4

    Default

    I am experiencing some difficulties matching numbers in two columns in Excel. My project requires me to figue out whether all the numbers in column A can be found in column B. Can anybody tell me how to do it? Thank you very much.


  2. #2
    Board Regular
    Join Date
    May 2002
    Posts
    132

    Default

    Not sure if this is the easiest or best way to go about this, but it works for me. Try copying your two columns to another worksheet.

    1. Change the font color of column A
    2. Cut column A and paste it in column B, underneath the last value in this column.
    3. Sort Ascending (A-Z) Now you should have just one column containing all data.
    4. In the next column over, insert this formula - IF(B1=B2,"Match","")

    Hope this works for you.

  3. #3
    Board Regular
    Join Date
    May 2002
    Posts
    132

    Default

    Add on to my last post:

    Drag your formula =IF(B1=B2,"Match","") down to the last value in column B

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    63,608

    Default

    On 2002-05-30 11:28, Bing wrote:
    I am experiencing some difficulties matching numbers in two columns in Excel. My project requires me to figue out whether all the numbers in column A can be found in column B. Can anybody tell me how to do it? Thank you very much.
    In column C enter and copy down as far as needed:

    =(COUNTIF(B:B,A2)>0)+0

    where A2 houses the first entry to check whether it is also in B.

    The formula gives 1 if A-entry occurs at least once in B, otherwise 0.

    You can also use conditional formatting on A to hilite the entries that are also in B.


    [ This Message was edited by: Aladin Akyurek on 2002-07-23 06:25 ]

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    15

    Default

    Cheers.

    That solution works great.
    And in record time too


Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com