| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Most hours worked
Hi I have a workbook containing colleagues' daily hours worked on separate sheets. I have then created a worksheet totalling how many hours per week each person has worked. How do I list the names in order of who has worked the most hours? I have the names in a row and the hours in the columns. I think I need some kind of auto sort that will display the names. thanks Steve -- spankydata ------------------------------------------------------------------------ spankydata's Profile: http://www.excelforum.com/member.php...o&userid=37217 View this thread: http://www.excelforum.com/showthread...hreadid=569313 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Most hours worked
Why don't you just sort them?
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "spankydata" wrote in message ... Hi I have a workbook containing colleagues' daily hours worked on separate sheets. I have then created a worksheet totalling how many hours per week each person has worked. How do I list the names in order of who has worked the most hours? I have the names in a row and the hours in the columns. I think I need some kind of auto sort that will display the names. thanks Steve -- spankydata ------------------------------------------------------------------------ spankydata's Profile: http://www.excelforum.com/member.php...o&userid=37217 View this thread: http://www.excelforum.com/showthread...hreadid=569313 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Most hours worked
On Tue, 08 Aug 2006 08:59:16 +0100, Bob Phillips
wrote: Why don't you just sort them? Yes, and obvously if this is a repetitive task. Record the sort as a macro and assign a button or command to it. -- Steve (3) |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Most hours worked
thanks I just wondered if excel could auto update the sort when new figures are input Steve -- spankydata ------------------------------------------------------------------------ spankydata's Profile: http://www.excelforum.com/member.php...o&userid=37217 View this thread: http://www.excelforum.com/showthread...hreadid=569313 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating numbers of hours worked in pay divisions | Excel Discussion (Misc queries) | |||
| Number of hours worked between 18:00 and 06:00 | Excel Worksheet Functions | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| Excel needs hh:mm where hh>24 for hours worked per week | Excel Worksheet Functions | |||
| calculate average hours worked | Excel Worksheet Functions | |||
Linear Mode
