Merge Multiple Records

The attached file shows one student with 3 records. The two records in blue font are for the same class so include all of the same information except for Visit Length (Column L) and the other record is for a different course. I would like to merge the two records that are for the same class and sum the visit length (leave all other variables as is). So once the process is complete, the same student would show two total records only.

What would you want to do about the dates, 4/5/2011 and 4/26/2011?

Originally Posted by JeteMc

What would you want to do about the dates, 4/5/2011 and 4/26/2011?

I could exclude that column from the final output or delete the column

Originally Posted by FDibbins

Do you want to update teh existing table (delete duplicate rows)? or do you want this in a new table (on a new sheet)?

I do not have a preference if the outcome would be the same

This will find rows in which three main values (Student ID, Reason, Tutor) are matched and sum the time spent with the tutor for those rows. It takes into account your answer to FDibbins' insightful question about a table for output on a separate sheet which omits the Visit Date as per your answer to me. It also makes use of several helper columns, which are automatically generated so that there is no extra input required.

Tutoring Time.xlsx

Hope that this is helpful.

Thank you! This is very helpful. I tried to copy my data into your file and noticed that the data is not always getting aggregated if the rows contain the same information. I'm not sure if this is a formatting issue or because there are cases when a student has more than 2 identical records. I will research further to see if I can adjust the formula on my end. Thank you.

You can set up the PivotTable to look almost exactly like the aggregated rows on my output sheet.

Tutoring Time.xlsx

As per the amended data, it can handle cases where there are more than two records that apply to the same student, as well as cases where the records are not contiguous.

If the student has more than two identical records the formula will not catch the third, etc. Sorry about that, I was going by the example. I'll see if I can make an adjustment, and perhaps some of the high power solvers on here can take a look in the meantime. I do have a question, have you considered using a pivot table?
I played around with that a little and it seems that would be a lot simpler, if the output meets your needs. (Popipipo beat me to that one)