+ Reply to Thread
Results 1 to 4 of 4

Match same data from diff. columns and group them under unique values

  1. #1
    Registered User
    Join Date
    06-21-2012
    Location
    Greece
    MS-Off Ver
    Excel 2007
    Posts
    30

    Match same data from diff. columns and group them under unique values

    Hello all,
    This is something I am trying to solve but no luck up till now...at least with an easy way.
    In the attached sample file, what I want to achieve is:
    A) Match/Group the ports that are present in the columns from E to L, both those who are repeated (duplicates as I have tried to show with conditional formatting) and those who are not (unique for instance).
    B) All must correspond to the bigger list of ports (that contains them all) in column B with a representative number as showed.
    *Note that Column L (F header) is related with prices in the columns M & N that I would like to be able to link later on for each port of F.
    As I am not very familiar with complex formulas, I am trying to match the ports with VLOOKUP, conditional formatting that I cannot easily cope with (a mess with the colors) and lot of manual work.
    Currently trying to understand how Index/Match functions work...

    Will appreciate if you can give me your lights!

    Thank you in advance
    Attached Files Attached Files
    Last edited by iliasark; 06-21-2012 at 04:35 PM.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Match same data from diff. columns and group them under unique values

    Match/Group the ports that are present in the columns from E to L,
    You want to match the ports available in Column E to L .. but with whom you are matching ? and where you want the resultant match number to appear?

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    06-21-2012
    Location
    Greece
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Match same data from diff. columns and group them under unique values

    Hello,

    I wanted to delete this thread but could not. I actually made another more clear here
    http://www.excelforum.com/excel-gene...-to-match.html

    how is possible to delete this thread?
    thanX

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Match same data from diff. columns and group them under unique values

    Hi iliasark,

    Please get in touch with any available person at :-

    http://www.excelforum.com/showgroups.php

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ 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