+ Reply to Thread
Results 1 to 3 of 3

Combine rows of data based on multiple criteria?

  1. #1
    Registered User
    Join Date
    03-06-2014
    Location
    Valparaiso, FL
    MS-Off Ver
    Excel 2013
    Posts
    73

    Combine rows of data based on multiple criteria?

    I have a table of college classes that are uniquely identified by their Reference number. If a student is in class for 8 or more hours, they get 1 hour lunch break. The data set I am given breaks up the whole class day if there is a lunch break. Is there any way with VBA to combine the rows so each class/date range has one row? I would also like to have the total hours for the class day to show up in the last column.
    Can VBA do something like this? Many thanks!!!


    combined.xlsx

  2. #2
    Registered User
    Join Date
    10-07-2015
    Location
    Vancouver, BC, Canada
    MS-Off Ver
    Office 365
    Posts
    22

    Re: Combine rows of data based on multiple criteria?

    dear hopegriffin

    please check the attached file
    in this way you can calculate the total time for every one in each day. Please comment on my Excel blog if you have questions.
    Attached Files Attached Files
    Last edited by bsuperiorsystem; 10-25-2015 at 11:15 PM.

  3. #3
    Registered User
    Join Date
    03-06-2014
    Location
    Valparaiso, FL
    MS-Off Ver
    Excel 2013
    Posts
    73

    Re: Combine rows of data based on multiple criteria?

    What a clean, elegant solution!! Perfect! Thank you so much!

+ 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. [SOLVED] Combine multiple rows with a certain criteria into one row
    By mhf89 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-16-2015, 03:40 PM
  2. Combine Data in Multiple Columns to One Column Based on Data in Rows
    By exceldivx in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-09-2014, 07:35 AM
  3. Returning multiple rows of data based on certain criteria
    By ghurhu in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-19-2012, 03:54 AM
  4. Replies: 2
    Last Post: 12-16-2011, 09:23 AM
  5. Remove data based on criteria from multiple columns and rows
    By jvegastn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-09-2009, 11:42 AM
  6. Combine muliple rows into one based on criteria
    By smb2004 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-08-2007, 10:38 PM
  7. [SOLVED] [SOLVED] return multiple rows of data based on criteria
    By steve_sr2 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-28-2006, 12:15 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