+ Reply to Thread
Results 1 to 3 of 3

Compare and return similar values

  1. 08-30-2012, 11:37 AM #1
    jackyong1985
    jackyong1985 is offline
    Registered User
    Join Date
    06-06-2012
    Location
    Philippine
    MS-Off Ver
    Excel 2007
    Posts
    16

    Compare and return similar values

    Hi,

    I've a list of data in column A and B. I will need the correct data to be appears in column C. It would be much appreciated if there's someone to assist me on this. Please find the excel file attached. Thanks.

    Regards,
    Jack
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-30-2012, 11:53 AM #2
    twiggywales
    twiggywales is offline
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: Compare and return similar values

    try this array formula 

    Please Login or Register  to view this content.
    (ctrl+shift+enter)

    Book1.xlsx

    (the circular waning is from yours that will go when you delete your attempt
    The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
    <--- If a post helps hit the star
    Reply With QuoteRegister To Reply
  3. 08-30-2012, 11:59 AM #3
    jackyong1985
    jackyong1985 is offline
    Registered User
    Join Date
    06-06-2012
    Location
    Philippine
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Compare and return similar values

    Thanks. This array formula works fine.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1