MrExcel Publishing
Your One Stop for Excel Tips & Solutions

subtotal


Posted by pat on March 26, 2001 5:26 AM

how do I sort months into columns, must repeat for a number of employees, and then subtotal

employee id month no actual hours
EEIABEK 1 -0.5
EEIABEK 1 7.5
EEIABEK 2 4
EEIABEK 3 1
EEIABEK 3 1
EEIABEK 3 1
EEIABEK 3 2


Posted by Mark W. on March 27, 2001 5:43 AM

Use a PivotTable.