Please help...
Hi...well here's my problem..and i need the solution asap.the columns below
are in one sheet.what i want is the weekly total for each account number
specific to each laborcode.eg=for account 1000,i want to calculate the weekly
total for labor codes 5006 and 5000. All in another sheet.
A B C
Accno LaborCode Weekly Total
1000 5006 39.5
2001 5006 4.5
2002 5000 2.5
1000 5006 29
2002 5006 11
2001 5000 1
I want my result to look like this but in another sheet or even the same
sheet.
LC 1000 2000 2001
5000 ? ? ?
5001
5006
Please get back to me anyone..thank you.
|