+ Reply to Thread
Results 1 to 2 of 2

Comparing columns of different size

Hybrid View

  1. #1
    Registered User
    Join Date
    11-01-2012
    Location
    Aberdeen
    MS-Off Ver
    Excel 2016
    Posts
    60

    Comparing columns of different size

    Hi everyone.
    I have a sheet with names and numbers. I wish to compare the telephone numbers of a different column and at the point i have a match then the corresponding name should be copied next to the identical number. The two telephone numbers columns are of unequal size.
    Any help appreciated
    Thanks

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Comparing columns of different size

    Hi
    Try this
    Formula: copy to clipboard
    =IFERROR(MATCH(B2,$A$2:$A$8,0)>0,FALSE)

    =IFERROR(MATCH(B2,$A$2:$A$8,0)>0,FALSE)
    to compare list A2:A8 with B2...
    Regards

+ 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. Create Columns Comparing differences in Other Columns
    By mvannucci in forum Excel General
    Replies: 1
    Last Post: 08-02-2015, 07:56 PM
  2. Comparing different size of tables
    By arcsibald in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2014, 12:02 PM
  3. Replies: 3
    Last Post: 04-23-2014, 05:14 PM
  4. Replies: 2
    Last Post: 04-18-2013, 02:03 PM
  5. Replies: 2
    Last Post: 03-15-2013, 05:25 PM
  6. Replies: 1
    Last Post: 02-05-2013, 10:56 AM
  7. [SOLVED] IF AND or SUMIFS comparing Months from 2 date columns and text from 2 other columns
    By jrochet in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-22-2012, 11:06 AM

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