How to Select Every Fourth Excel Row

D

davey11372

Board Regular
Joined
Dec 19, 2009
Messages
56
I have a list of stock prices. One column has the time, every minute, and the next column has the respective stock price.

How can I select every fourth row of the stock price column (in other words instead of selecting the entire column, I want to skip two minutes between data selected)? I will then copy and paste the selected data to a separate column in the same / or different sheet.

The following is some sample data. The green data cells, going all the way down, is what I am trying to select. Thank you.

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 10">****** name="Originator" content="Microsoft Word 10"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cdevray1%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><o:smarttagtype namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="time"></o:smarttagtype><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if !mso]>******** classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object> <style> st1\:*{behavior:url(#ieooui) } </style> <![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]--> <table class="MsoNormalTable" style="width: 113.6pt; margin-left: 5.4pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="151"> <tbody><tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="0" hour="13">1:00:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.89<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="1" hour="13">1:01:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.88<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="2" hour="13">1:02:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.89<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="3" hour="13">1:03:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.9<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="4" hour="13">1:04:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.96<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="5" hour="13">1:05:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="48.962499999999999" nowrap="nowrap" valign="bottom" width="65">
48.9625<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="6" hour="13">1:06:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.98<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="7" hour="13">1:07:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.99<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="8" hour="13">1:08:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.98<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="9" hour="13">1:09:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.99<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="10" hour="13">1:10:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.93<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="11" hour="13">1:11:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.9<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="12" hour="13">1:12:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.91<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="13" hour="13">1:13:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.92<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="14" hour="13">1:14:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.92<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="15" hour="13">1:15:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.92<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="16" hour="13">1:16:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.93<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="17" hour="13">1:17:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.95<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="18" hour="13">1:18:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="48.940899999999999" nowrap="nowrap" valign="bottom" width="65">
48.9409<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="19" hour="13">1:19:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="48.940899999999999" nowrap="nowrap" valign="bottom" width="65">
48.9409<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="20" hour="13">1:20:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.95<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="21" hour="13">1:21:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.94<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="22" hour="13">1:22:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.96<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="23" hour="13">1:23:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
49<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="24" hour="13">1:24:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.98<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="25" hour="13">1:25:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="48.984999999999999" nowrap="nowrap" valign="bottom" width="65">
48.985<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="26" hour="13">1:26:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.95<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="27" hour="13">1:27:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.95<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="28" hour="13">1:28:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.95<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="29" hour="13">1:29:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.96<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="30" hour="13">1:30:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.95<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="31" hour="13">1:31:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.95<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="32" hour="13">1:32:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.94<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="33" hour="13">1:33:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.92<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="34" hour="13">1:34:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="48.891800000000003" nowrap="nowrap" valign="bottom" width="65">
48.8918<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="35" hour="13">1:35:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="48.875" nowrap="nowrap" valign="bottom" width="65">
48.875<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="36" hour="13">1:36:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.87<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="37" hour="13">1:37:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.87<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="38" hour="13">1:38:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.88<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="39" hour="13">1:39:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.89<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="40" hour="13">1:40:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.89<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="41" hour="13">1:41:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.93<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="42" hour="13">1:42:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.91<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="43" hour="13">1:43:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.9<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="44" hour="13">1:44:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.87<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="45" hour="13">1:45:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.85<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="46" hour="13">1:46:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.81<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="47" hour="13">1:47:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.78<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="48" hour="13">1:48:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="48.751300000000001" nowrap="nowrap" valign="bottom" width="65">
48.7513<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="49" hour="13">1:49:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.77<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="50" hour="13">1:50:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.77<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="51" hour="13">1:51:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.77<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="52" hour="13">1:52:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="48.805" nowrap="nowrap" valign="bottom" width="65">
48.805<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="53" hour="13">1:53:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.82<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="54" hour="13">1:54:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.81<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="55" hour="13">1:55:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.81<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="56" hour="13">1:56:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.8<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="57" hour="13">1:57:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.83<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="58" hour="13">1:58:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.85<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="59" hour="13">1:59:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="48.866" nowrap="nowrap" valign="bottom" width="65">
48.866<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="0" hour="14">2:00:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.87<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="1" hour="14">2:01:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.85<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="2" hour="14">2:02:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.86<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="3" hour="14">2:03:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.88<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="4" hour="14">2:04:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.88<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="5" hour="14">2:05:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.85<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="6" hour="14">2:06:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.87<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="7" hour="14">2:07:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.92<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="8" hour="14">2:08:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.91<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="9" hour="14">2:09:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.91<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="10" hour="14">2:10:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.89<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="11" hour="14">2:11:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.91<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="12" hour="14">2:12:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.9<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="13" hour="14">2:13:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="48.9298" nowrap="nowrap" valign="bottom" width="65">
48.9298<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="14" hour="14">2:14:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.92<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="15" hour="14">2:15:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.92<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="16" hour="14">2:16:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.89<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="17" hour="14">2:17:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.9<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="18" hour="14">2:18:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="48.911999999999999" nowrap="nowrap" valign="bottom" width="65">
48.912<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="19" hour="14">2:19:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.9<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="20" hour="14">2:20:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="48.908000000000001" nowrap="nowrap" valign="bottom" width="65">
48.908<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="21" hour="14">2:21:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.89<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="22" hour="14">2:22:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.89<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="23" hour="14">2:23:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.94<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="24" hour="14">2:24:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.87<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0in 5.4pt; width: 0.9in; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="86"> <st1:time minute="25" hour="14">2:25:00 PM</st1:time><o:p></o:p>
</td> <td style="padding: 0in 5.4pt; width: 48.8pt; height: 12.75pt;" x:num="" nowrap="nowrap" valign="bottom" width="65">
48.87<o:p></o:p>​
</td> </tr> </tbody></table>

<table x:str="" style="border-collapse: collapse; width: 96pt;" border="0" cellpadding="0" cellspacing="0" width="128"><col style="width: 48pt;" span="2" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 48pt;" height="17" width="64">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td style="width: 48pt;" x:num="" align="right" width="64">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="48.984999999999999" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="48.999899999999997" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="48.984999999999999" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="48.844999999999999" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="48.965000000000003" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="48.957900000000002" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="48.962499999999999" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt;" height="17">
</td><td style="vertical-align: top;">
</td><td style="vertical-align: top;">
</td><td x:num="" align="right">
</td></tr></tbody></table>
 
Sort by date Sort by votes
You could put 1 in the top cell of an empty column then in the second cell enter:

=MOD(C1+1,4)

and copy it down (assumes you use the C column). Then just filter that column for all values that equal 1.

Dave
 
Upvote 0
Dave, Thank you.

I tried it out, in a simple application, and it seems to work. Will try it out in a more complex final application later.

Have a nice day.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
968
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
3K
Attrazion
A
E
  • Question Question
VBA for Web Scraping help
Replies
0
Views
1K
epactheactor
E
D
  • Question Question
Problems Encountered When Generating VBA Excel Charts with 15-Minute Interval Data.
Replies
0
Views
409
dilshod_k
D
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C

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