+ Reply to Thread
Results 1 to 5 of 5

Combining some of the rows Values based on multiple criteria (2)

Hybrid View

  1. #1
    Registered User
    Join Date
    04-18-2014
    Location
    Belgium, Brussel
    MS-Off Ver
    Excel 2007
    Posts
    3

    Combining some of the rows Values based on multiple criteria (2)

    Hey,

    My name is Sven and I'm currently struggling with the following problem:
    I have a table based on transportnumbers who sometimes have doubles.
    Example:

    Number Postcode Value1 Value 2...
    106200 8500 10
    106200 8500 5
    106200 8600 6
    106201 5500 4
    106202 4000 1
    106202 4000 1

    So it works as following: A transportnumber can have multiple instances of itself, such as 106200. This transportnumber can also have multiple instances where the postcode is the same. These are the rows i want to combine
    So shortly:
    Transportnumber double/triple...+ Postcode double/triple...= combine these rows.
    if only transportnumber is double, or only postcode, then dont combine.

    I want it to combine 2 colums of values, one will b the kgs, other one a price.

    So example of end result for 106200 would be
    106200 8500 value+value (these 2 rows matched so it combined the 2 values i want it to)
    106200 8600 value ( this was unique so it stays unique)

    I hope i explained this well, looking forward to any input

    Rgds, Sven

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,610

    Re: Combining some of the rows Values based on multiple criteria (2)

    Hi and welcome

    would a Pivot Table do? ( perhaps post a sample heet showing BEFORE and AFTER)

  3. #3
    Registered User
    Join Date
    04-18-2014
    Location
    Belgium, Brussel
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Combining some of the rows Values based on multiple criteria (2)

    I will make one with pictures right now. Good idea.

  4. #4
    Registered User
    Join Date
    04-18-2014
    Location
    Belgium, Brussel
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Combining some of the rows Values based on multiple criteria (2)

    Okay so apparently there are some restrictions to the company pc i'm working from so pictures wont be working. Instead i'll just tell you what i did.

    i made a pivot, sorted by transport numbers, and postcode below that. then added in volume and price as values.
    The problem is: This is how the sort comes out:

    Transportnumber Value1 Value2
    -Postcode1
    -Postcode2
    -Postcode...
    Transportnuber2 Value 1 Value2
    .....

    If i could hide the row of transportnumber, id have a list of all the postcodes and volumes etc next to it, which is also fine for me.
    If i were to make a formula now and drag it down it would also include the transportnumber row with totals every time before it lists the postcodes.

  5. #5
    Registered User
    Join Date
    04-18-2014
    Location
    Belgium, Brussel
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Combining some of the rows Values based on multiple criteria (2)

    Okay I managed to find a way but it was kind of tricky.

    I made a pivot table, sorted rows by Transport/postcode, value were volume + prices.
    Then i went into pivottable options, changed the display to classic pivottable layout, and then rightclicked the table again and removed the subtotals.
    This gave me a clean list and something i can work with.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Combining Rows Based On Matching Values in one column
    By jeffocasm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-15-2013, 07:16 PM
  2. [SOLVED] Sum if based on two criteria and values in multiple rows and columns
    By Alkina in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-15-2013, 09:18 AM
  3. Combining Text from multiple Rows based on Unique ID
    By lee2k60 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2013, 12:11 AM
  4. Replies: 6
    Last Post: 10-18-2012, 03:10 PM
  5. Replies: 2
    Last Post: 12-16-2011, 09:23 AM

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