Results 1 to 4 of 4

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

Threaded View

  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.

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