I have spreadsheet that has duplicate entries of employee names and their
hours worked. There could up to three entries for one employee with
additional hours worked. There is regular time and overtime hours. I want to
combine the hours so that they appear all in one line like a subtotal for
each employee. I know I can use subtotal for this but I would rather use a
macro or a formula to eliminat steps.