How can I look for specific value in a column and return it until another specified value occurs, then return that, etc.?

ncjefffl

New Member
Joined
May 5, 2010
Messages
22
:banghead: I am trying to eliminate some repetitive copy/pasting in a monthly worksheet. I have two columns. One contains a single occurence of a day name (Monday thru Sunday) with timeslots for each day (but also empty spaces and other info because it comes from a report pasted into the sheets). A sample is below, just of Monday and part of Tuesday, but it goes on down.

<TABLE style="WIDTH: 384pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=512 border=0><COLGROUP><COL style="WIDTH: 359pt; mso-width-source: userset; mso-width-alt: 12262" width=479><COL style="WIDTH: 25pt; mso-width-source: userset; mso-width-alt: 844" width=33><TBODY><TR style="HEIGHT: 4.5pt; mso-height-source: userset" height=6><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 4.5pt; BACKGROUND-COLOR: transparent" width=479 height=6></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" width=33></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl68 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: gray 2pt double; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=479 height=18>MONDAY</TD><TD class=xl68 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: gray 2pt double; BACKGROUND-COLOR: transparent" width=33></TD></TR><TR style="HEIGHT: 5.25pt; mso-height-source: userset" height=7><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 5.25pt; BACKGROUND-COLOR: transparent" height=7></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=479 height=17>Period Start</TD><TD class=xl65 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" width=33>SCH</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD class=xl69 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" width=479 height=22></TD><TD class=xl69 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent" width=33></TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>08:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>13</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>08:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>13</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>09:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>14</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>09:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>14</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>10:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>15</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>10:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>14</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>11:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>15</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>11:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>16</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>12:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>14</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>12:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>14</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>13:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>8</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>13:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>13</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>14:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>18</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>14:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>19</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>15:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>21</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>15:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>21</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>16:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>18</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>16:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>13</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>17:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>13</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>17:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>15</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>18:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>14</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>18:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>11</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>19:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>11</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>19:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>9</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>20:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>8</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>20:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>9</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>21:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>8</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>21:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>7</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>22:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>6</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>22:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>5</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>23:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>5</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>23:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>5</TD></TR><TR style="HEIGHT: 15.75pt; mso-height-source: userset" height=21><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 2.25pt; mso-height-source: userset" height=3><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 2.25pt; BACKGROUND-COLOR: transparent" height=3></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=479 height=17>Summary</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>197</TD></TR><TR style="HEIGHT: 3pt; mso-height-source: userset" height=4><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 3pt; BACKGROUND-COLOR: transparent" height=4></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl68 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: gray 2pt double; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=479 height=18>TUESDAY</TD><TD class=xl68 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: gray 2pt double; BACKGROUND-COLOR: transparent" width=33></TD></TR><TR style="HEIGHT: 5.25pt; mso-height-source: userset" height=7><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 5.25pt; BACKGROUND-COLOR: transparent" height=7></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=479 height=17>Period Start</TD><TD class=xl65 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" width=33>SCH</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD class=xl69 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" width=479 height=22></TD><TD class=xl69 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent" width=33></TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>08:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>15</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>08:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>15</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>09:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>15</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>09:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>16</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>10:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>15</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>10:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>14</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>11:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>18</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>11:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>19</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>12:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>16</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>12:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>15</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>13:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>16</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>13:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>23</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>14:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>22</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>14:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>23</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>15:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>23</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>
What I want to do is put a formula in column C that will populate with the days, changing when they do. In other words, it will return "Monday" until it encounters "Tuesday", then "Tuesday" until it encounters "Wednesday", etc. I haven't been able to come up with anything. Does anyone know how I can do it (or if it can't be done)?

Just in case I'm getting too baroque in what I'm attempting, I'll further explain my ultimate goal in case anyone has a better idea:

What I want to do is create a vlookup based on a daily list of times from 12:30am through 11:30pm. It will go into the report above, and for each day pull the SCH number for any timeslot that appears in the report for that day. The only way I can think to do that, since each day will have a different number of timeslots from month to month, is to create a column tagging every cell between each day with the day name (ie, every cell in column C would say "Monday" until Tuesday appears in column A, then "Tuesday" until "Wednesday" appears in column A, etc thru Sunday. I just can't figure out a way to say, "vlookup the time value in the range of cells between cells containing the day names". I thought I had it by naming the ranges, until I realized that the range for each day might fluctuate monthly, depending on how many timeslots each day has, which can vary. Monday may have more one month and less another which will change the range of cells between Monday and Tuesday from one month to another, making the named range invalid (unless there's a way to make the named range variable?).

I hope this makes sense. Any help, as always, is much appreciated!
(I'm using Excel 2007, btw)
 

ncjefffl

New Member
Joined
May 5, 2010
Messages
22
Just checking~is my question confusing or is it just that nobody has a solution ("yet", he amended hopefully)?
 

Ruddles

Well-known Member
Joined
Aug 24, 2010
Messages
5,773
Sorry, I only just saw this! Is the day-of-the-week always followed in the very next row by the words "Period Start"?

If so, this in C1: =A1
This in C2: =IF(A3="Period Start",A2,C1)
And copy C2 down as far as necessary.

Any good?
 
Last edited:

ncjefffl

New Member
Joined
May 5, 2010
Messages
22
Yep, that is a copy of the top part of the spreadsheet and the lines between days are identical (although not necessarily the spacing. That's the same except when a day has no data. Example below).

<TABLE style="WIDTH: 420pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=560 border=0><COLGROUP><COL style="WIDTH: 359pt; mso-width-source: userset; mso-width-alt: 12262" width=479><COL style="WIDTH: 25pt; mso-width-source: userset; mso-width-alt: 844" width=33><COL style="WIDTH: 36pt; mso-width-source: userset; mso-width-alt: 1228" width=48><TBODY><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>22:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>0</TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 36pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" width=48></TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>23:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>0</TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>23:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>0</TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt; mso-height-source: userset" height=21><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 2.25pt; mso-height-source: userset" height=3><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 2.25pt; BACKGROUND-COLOR: transparent" height=3></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=479 height=17>Summary</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>96</TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 3pt; mso-height-source: userset" height=4><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 3pt; BACKGROUND-COLOR: transparent" height=4></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl68 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: gray 2pt double; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=479 height=18>SATURDAY</TD><TD class=xl68 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: gray 2pt double; BACKGROUND-COLOR: transparent" width=33></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 5.25pt; mso-height-source: userset" height=7><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 5.25pt; BACKGROUND-COLOR: transparent" height=7></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=479 height=17>Period Start</TD><TD class=xl65 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" width=33>SCH</TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD class=xl69 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" width=479 height=22></TD><TD class=xl69 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent" width=33></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt; mso-height-source: userset" height=21><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 2.25pt; mso-height-source: userset" height=3><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 2.25pt; BACKGROUND-COLOR: transparent" height=3></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=479 height=17>Summary</TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 3pt; mso-height-source: userset" height=4><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 3pt; BACKGROUND-COLOR: transparent" height=4></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl68 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: gray 2pt double; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=479 height=18>SUNDAY</TD><TD class=xl68 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: gray 2pt double; BACKGROUND-COLOR: transparent" width=33></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 5.25pt; mso-height-source: userset" height=7><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 5.25pt; BACKGROUND-COLOR: transparent" height=7></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=479 height=17>Period Start</TD><TD class=xl65 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" width=33>SCH</TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD class=xl69 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" width=479 height=22></TD><TD class=xl69 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent" width=33></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt; mso-height-source: userset" height=21><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 2.25pt; mso-height-source: userset" height=3><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 2.25pt; BACKGROUND-COLOR: transparent" height=3></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=479 height=17>Summary</TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 3pt; mso-height-source: userset" height=4><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 3pt; BACKGROUND-COLOR: transparent" height=4></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 409.6pt; mso-height-source: userset" height=546><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 409.6pt; BACKGROUND-COLOR: transparent" height=546></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>
 

ncjefffl

New Member
Joined
May 5, 2010
Messages
22
my apologies. I didn't see the formula you typed after your question. Let me give it a try and I'll let you know.

Thanks!!
 

ncjefffl

New Member
Joined
May 5, 2010
Messages
22
That works! So simple; I don't know why I couldn't work that out myself! Thank you so much!

Out of curiousity, IS there a way to write a vlookup that would search between the days without having to have column C populate this way? Or better yet, a way to create a variable named range that would adjust itself based on encountering changes in the day name?

For instance, if I created two named ranges, Monday (defined A5-A20) and Tuesday (defined as A25-A40), is is possible to make them recognize that if the word "Tuesday" occurs within A5-A20 (say in A18) that the Monday range should adjust to be A5-A16, or something like that?

I don't ask for much, do I? .
 

Ruddles

Well-known Member
Joined
Aug 24, 2010
Messages
5,773
As there are no dates in the data, can I assume we're only ever looking at one occurrence of each weekday at a time?

If so, I suppose it would be possible for a function to find the row containing the day of the week you're interested in and use that as the start row for the lookup, then find the row containing the next occurrence of the word "Summary" and use that as the last row for the lookup, but it would be horrendous.

Personally - and people differ - I tend to revert to using VBA to do this sort of thing as soon as worksheet formulae get too complex. VBA has the advantage that you can code some extremely complex operations in a very few commands, format your code so that it's easy to read and pepper it with explanatory comments.

I'm not promising anything but based on the sample data in your original post, exactly what would you expect the output be?
 

ncjefffl

New Member
Joined
May 5, 2010
Messages
22
That is a correct assumption. No dates. The output would simply be the numbers in the SCH column (column B) pulled into wherever I put the formula (or where I told the VBA to put it. The destination will always be static. There I have daily columns (Monday-Sunday) with half hour time slots from midnight to 11:30 pm and just need to pull the SCH number into the corresponding time slot for a given day.

Unfortunately, I know virtually nothing about writing VBA. When I use it, I usually just record something I'm doing or copy someone else's code. I've had some success at modifying a VBA code from this site and getting it to do slightly different things or account for differences in my data, but I don't usually understand what I'm doing. :(

I really need to learn VBA because you wouldn't believe some of the baroque formulas I've come up with!
 

ncjefffl

New Member
Joined
May 5, 2010
Messages
22
Rudy, you are genius, a saint, a lion among men! :pray:

The macro you sent me has reduced a project that took 3-4 hours to 30-45 minutes AND got rid of the most tedious parts of it.

It was extraordinary of you to spend so much time on it and I can't thank you enough (nor reward you with cash and prizes, so I'm trying to be especially fulsome in my praise). You really went the extra several miles and God will hear of this!

If I ever make it to the UK, the rounds are on me! (y)

Thanks again!

Jeff
 

Forum statistics

Threads
1,082,119
Messages
5,363,272
Members
400,724
Latest member
Angeljurich15

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top