Subtotal hours everytime Excel finds a new name

[oomfh]

We dump a list of names and hours into a .xls file, then sort the rows by name.

What is the best method to have Excel automatically subtotal the hours everytime it finds a new name (value)?

Names in column A, hours in column B. It is not important which column the subtotals appear, but a Pivot Table would result in too many columns.

 

[circledchicken]

Hi,

I'm not sure what you mean by the PivotTable resulting in too many columns but Excel 2010 has a subtotal feature in the Data tab on the ribbon:
How to Insert Subtotals in an Excel 2010 Worksheet - For Dummies

 

[oomfh]

Hi,

I'm not sure what you mean by the PivotTable resulting in too many columns but Excel 2010 has a subtotal feature in the Data tab on the ribbon:
How to Insert Subtotals in an Excel 2010 Worksheet - For Dummies

Perfect, thx