Hi,
I have another question/problem and am coming to you for help...
Attached is the spreadsheet in question.
- Column A: Employee
- Column B: Hours
- Column C: Work Description
I'd like to see which work description had the most hours, by employee. The subtotal feature did not accomplish this for me I've got over 1100 employees to do this for. Some employees worked one job, some worked over 10.
Aaron 10 Log Vault 312 Manifold Aaron 10 Log Vault 312 Manifold Aaron 10 Log Vault 312 Manifold Aaron 10 Log Vault 312 Manifold Aaron 10 Log Vault 312 Manifold Aaron 10 Log Vault 312 Manifold Aaron 10 Log Vault 312 Manifold Aaron 5 Log Vault 312 Manifold Aaron 1.5 Boiler Outage Aaron 1.5 Boiler Outage Aaron 1.5 Boiler Outage Aaron 10 Boiler Outage Aaron 10 Boiler Outage Aaron 10 Boiler Outage Aaron 8 Boiler Outage Aaron 9 H2S Monitoring Aaron 6 H2S Monitoring Aaron 1 H2S Monitoring Aaron 1.5 H2S Monitoring Aaron 8 H2S Monitoring Aaron 3.5 H2S Monitoring Aaron 6.5 H2S Monitoring Aaron 8 H2S Monitoring Hak 8 6" Drain Line Hak 3 6" Drain Line Hak 8 6" Drain Line Hak 8 6" Drain Line Hak 8 Fab 10 ea chem clean hdrs Hak 8 Fab 10 ea chem clean hdrs Hak 8 Fab 10 ea chem clean hdrs Hak 8 Fab 10 ea chem clean hdrs Hak 7 Fab 10 ea chem clean hdrs Hak 4 Fab 10 ea chem clean hdrs Hak 2 Fab 10 ea chem clean hdrs Hak 8 Fab HA/HE Quadrant frames Hak 8 Fab HA/HE Quadrant frames Hak 8 Fab HA/HE Quadrant frames Hak 8 Fab HA/HE Quadrant frames Hak 8 Fab HA/HE Quadrant frames Hak 8 Fab HA/HE Quadrant frames Hak 2 Fab HA/HE Quadrant frames Hak 2 Fab HA/HE Quadrant frames Hak 4 Fab HA/HE Quadrant frames Hak 3.5 Fab HA/HE Quadrant frames Hak 2 Fab HA/HE Quadrant frames Hak 2 Fab HA/HE Quadrant frames Hak 2.5 Fab HA/HE Quadrant frames Hak 8 Fab unit 65 Hak 8 Fab unit 65
Thank you again
Bookmarks