View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BAKERSMAN BAKERSMAN is offline
external usenet poster
 
Posts: 36
Default Sort list of names

I have a list of employee names in column "A" and the total hrs they worked
for a specific date range in column "B". Some of the employees work in
differnet departments so their name shows up twice with 2 different hour
totals. I need to be able to sum the total amount of hours worked for each
individuals total hrs work for all departments for a specific time frame. I
want to have a list of all the employee names in colum "C" with total hrs
work for all combined deparments in column "D".