Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Rostering problem
Never had much to do with excel before, but am trying to work out a problem with a roster system. On sheet 1, the roster looks something like this Person a 700 Person b 1430 Person c 730 person d 1230 Person e 700 Person f 1430 Person g ARL Person h 930 Person i 930 Person j 700 column A being the persons name and column B is the time the shift starts. On sheet 2, I then want to retrieve the info and group it in time slots like so Person a 700 Person c 730 Person e 700 Person j 700 Person h 930 Person i 930 Person b 1430 person d 1230 Person f 1430 so it can be printed off for a daily allocation sheet. Any help would be greatly appreciated. Thanx :) -- Hartygan ------------------------------------------------------------------------ Hartygan's Profile: http://www.excelforum.com/member.php...o&userid=26634 View this thread: http://www.excelforum.com/showthread...hreadid=399104 |
#2
|
|||
|
|||
Any suggestions? -- Hartygan ------------------------------------------------------------------------ Hartygan's Profile: http://www.excelforum.com/member.php...o&userid=26634 View this thread: http://www.excelforum.com/showthread...hreadid=399104 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
EXCEL 2003 PROBLEM | Excel Worksheet Functions | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) |