+ Reply to Thread
Results 1 to 2 of 2

Compare columns and finding matching values/text

Hybrid View

  1. 02-02-2014, 09:27 AM #1
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Compare columns and finding matching values/text

    A formula like this will help:


    
=IF(A2=B2,"X","O")&IF(A2=C2,"X","O")&IF(A2=D2,"X","O")
    Attached Files Attached Files
    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)

Similar Threads

  1. [SOLVED] Finding matching values from different columns
    By hefe_espada in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-23-2013, 07:24 PM
  2. Compare and count the matching values from different columns
    By Mary Jean Laura in forum Excel General
    Replies: 1
    Last Post: 07-04-2012, 10:41 AM
  3. Excel 2007 : Need to Compare three columns for matching values and populate a predetermined Value.
    By jinsi.george in forum Excel General
    Replies: 4
    Last Post: 03-20-2012, 03:02 PM
  4. Compare 2 columns delete rows with matching values
    By mattmac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-05-2009, 01:50 PM
  5. [SOLVED] Compare cells/columns and highlight matching text strings
    By luxbelle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2005, 06:06 PM

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