Collapsing rows of duplicate dates in a column leaving one row with a subtotal?

Posted by Will on Super User See other posts from Super User or by Will
Published on 2012-10-06T20:48:44Z Indexed on 2012/10/06 21:40 UTC
Read the original article Hit count: 125

Filed under:

I have several thousand rows of date, time, and values in columns.

Each row is contains a date, time for that date, and a value for that time period (hour)

So each 24 rows has the same date with each having the next hour of the day.

I'd like to collapse or group the 24 rows leaving the last row with a subtotal of the value (column D) to the right in column F.

While this can obviously be done manually, several years of data would take a while and there ought to be a way to do this other wise?

© Super User or respective owner

Related posts about microsoft-excel