+ Reply to Thread
Results 1 to 3 of 3

comparing multiple columns

  1. #1
    Registered User
    Join Date
    10-19-2012
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    1

    comparing multiple columns

    Hi
    I have an excel sheet with multiple columns but i will try with three columns now. What i want is that the three columns should be compared and common numbers in the three columns should be displayed in another column.

    i have attached a sample sheet. i would be grateful if you can help me solving this

    thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,893

    Re: comparing multiple columns

    Looked at your file. Give us an example of what the expected results should look like and how you want it presented.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: comparing multiple columns

    the yellow cells match all columns (see the example)
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1