Hi,
I have a task, I was hoping someone out there could help.
I would like to keep track of hours spent working, and sort the employees by total hours.
Example:
Total Hours Name Day1 Day2 4 Bob 1 3 6 Jill 5 1 6 Zoey 5 1 7 Hal 1 6 9 Joe 4 5 11 Sam 4 7 13 Paul 4 9 14 Mary 8 6 14 Louis 6 8
I want the excel sheet to automatically sort the employees (and their cooresponding hours) as I input data...i.e.:
Total Hours Name Day1 Day2 Day3 7 Zoey 5 1 1 10 Bob 1 3 6 11 Hal 1 6 4 13 Sam 4 7 2 14 Jill 5 1 8 16 Paul 4 9 3 17 Joe 4 5 8 20 Mary 8 6 6 21 Louis 6 8 7
Is there any way to do this?
It can span several sheets if need be...
I'd really appreciate any help someone out there could lend. Thank you very much in advance!
-Justin
Edit: I just realized you can't copy/paste excel info into the window. I attached 2 pictures to illustrate what I'm trying to get at. I want excel (or some formula/code I put into excel) to sort this for me automatically.
I have a task, I was hoping someone out there could help.
I would like to keep track of hours spent working, and sort the employees by total hours.
Example:
Total Hours Name Day1 Day2 4 Bob 1 3 6 Jill 5 1 6 Zoey 5 1 7 Hal 1 6 9 Joe 4 5 11 Sam 4 7 13 Paul 4 9 14 Mary 8 6 14 Louis 6 8
I want the excel sheet to automatically sort the employees (and their cooresponding hours) as I input data...i.e.:
Total Hours Name Day1 Day2 Day3 7 Zoey 5 1 1 10 Bob 1 3 6 11 Hal 1 6 4 13 Sam 4 7 2 14 Jill 5 1 8 16 Paul 4 9 3 17 Joe 4 5 8 20 Mary 8 6 6 21 Louis 6 8 7
Is there any way to do this?
It can span several sheets if need be...
I'd really appreciate any help someone out there could lend. Thank you very much in advance!
-Justin
Edit: I just realized you can't copy/paste excel info into the window. I attached 2 pictures to illustrate what I'm trying to get at. I want excel (or some formula/code I put into excel) to sort this for me automatically.
Attachments
Last edited: