+ Reply to Thread
Results 1 to 1 of 1

How to consolidate rows based on MULTIPLE criteria?

  1. #1
    Registered User
    Join Date
    09-15-2017
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2007
    Posts
    4

    How to consolidate rows based on MULTIPLE criteria?

    Hey guys!

    I'm looking to merge several rows throughout a large dataset. However, I can't use Excel's consolidate function, since I need two cells in a row to duplicate with another two cells further down the dataset.

    I'm looking at data over the placement of automated cameras checking the speed of motorists and their revenues on each road location. However, each row is a unique placement on a certain road. I want to consolidate revenues etc. on each road in the same postcode. Since the roads can be very long going through several postcodes and counties. Therefore, it's important that only identical road revenues are merged if also the postcodes match.

    However, I can't seem to program excel to only sum cells F through I if cell B and cell D of the same row duplicate.

    Really would appreciate your help!

    I've attached a small data sample.
    Attached Files Attached Files

+ 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. Formula to Sum 3 Column Values based on Multiple Criteria for Multiple Rows
    By RMerckling in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2016, 07:46 PM
  2. Consolidate rows based on unique key from multiple sheets to an output sheet
    By sreeks in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-15-2015, 05:55 AM
  3. Replies: 5
    Last Post: 12-28-2012, 02:06 PM
  4. [SOLVED] Consolidate data in 2 rows into 1 row, based on column criteria
    By PeS in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-22-2012, 11:41 AM
  5. Consolidate rows from multiple worksheets in one based on cell criteria
    By SuperSman in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-11-2011, 10:28 AM
  6. Replies: 1
    Last Post: 05-18-2009, 11:21 AM
  7. Count Multiple Entries, Return Multiple Rows, Based On 3 Criteria
    By gtj_global in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-20-2008, 06:40 PM

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