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

ncjefffl

ncjefffl

New Member
Joined
May 5, 2010
Messages
22
:oops: 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)
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Sort by date Sort by votes
Just checking~is my question confusing or is it just that nobody has a solution ("yet", he amended hopefully)?
 
Upvote 0
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:
Upvote 0
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>
 
Upvote 0
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!!
 
Upvote 0
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? .
 
Upvote 0
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?
 
Upvote 0
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!
 
Upvote 0
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
826
gvsumich
G
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
M
  • Question
Help with FilterXML formula
Replies
0
Views
1K
montex01
M
D
  • Question
How to output a dynamic range where the height of the range varies
Replies
0
Views
971
dagda13
D

Forum statistics

Threads
1,214,911
Messages
6,122,198
Members
449,072
Latest member
DW Draft

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top