Results 1 to 8 of 8

Combining multiple cells into one (without losing data) if the rest of the row is equal

Threaded View

  1. #6
    Forum Contributor
    Join Date
    06-26-2013
    Location
    LAX
    MS-Off Ver
    Excel 2007,Excel 2010
    Posts
    363

    Re: Combining multiple cells into one (without losing data) if the rest of the row is equa

    Well, there may be big solutions/ vba code to extract the require data. My way to do this would be, extract the unique car model names and check the lowest and highest year it was made and group the years accordingly ( I have used data-->advance filter to get the unique model names... vlookup and index,sumproduct to get the low and high year based on the model names, which i have done in blad2)

    Then, i would apply the grouped years to all data per the model name. CONCATENATE all the columns to remove the duplicates and de CONCATENATE to get back the unique records.(which i have done in blad1).

    See if this example way of data extract helps. It's not huge task and can be done in few mins

    --------
    If my reply helped, Please add reputation (click on the star below the post)
    If the reply solves your problem, Don't forget to mark the thread as "Solved" (Thread Tools->Mark thread as Solved)
    Attached Files Attached Files

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