Clearing Rows That Don't Meet Criteria

M

mlarson

Well-known Member
Joined
Aug 25, 2011
Messages
509
Office Version
  1. 2010
Platform
  1. Windows
<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[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-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]--> Hi all, I am hoping you can help me with this problem. I am trying to clear/delete (whichever takes less time for the macro to run) rows of data that do not meet certain criteria. Here’s a description of the criteria:

Note: Data is in chronological order by date and time, and while this sample spreadsheet has less than 40 rows, my actual spreadsheet has about 700,000 rows. I am using Excel 2010.

Step one: I want to find the rows in which the first occurrence of “Text4” occurs in Column Y on each date (Column B). I want to keep those rows.

Step two: I then want to keep all other rows (doesn’t matter if they show “Text4” in Column Y or not) as long as they match the date (Column B) and value of Column H of the rows being kept in step one, and also have a time (Column D) that is later/larger than the time of the row kept in step one. Those that match date and Column H value but are earlier/smaller than the time of the row kept in step one can be cleared/deleted.

Step three (final step): I’d then like to sort the spreadsheet by (1) Date/Column B (oldest to newest), (2) Time/Column D (smallest to largest), and (3) Column G (A to Z).

In the example below you will see that the second spreadsheet (“desired output”) keeps rows 3, 14, and 31 based on step one because they each were the first occurrence on a given date that had “Text4.” The other rows are kept based on step two because they match the date and value of Column H of at least one of the rows kept from step one, and each has a time that is later/larger than the time of the row being kept of the same date.

I hope I have described this well enough. Thank you in advance if you are willing to help me with this. I appreciate it!


<table border="0" cellpadding="0" cellspacing="0" width="1664"><col style="width: 48pt;" width="64" span="4"> <col style="width: 48pt;" width="64"> <col style="width: 48pt;" width="64" span="21"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; width: 48pt;" width="64" height="20">
</td> <td class="xl66" style="width: 48pt;" width="64">A</td> <td class="xl66" style="width: 48pt;" width="64">B</td> <td class="xl66" style="width: 48pt;" width="64">C</td> <td class="xl67" style="width: 48pt;" width="64">D</td> <td class="xl66" style="width: 48pt;" width="64">E</td> <td class="xl66" style="width: 48pt;" width="64">F</td> <td class="xl66" style="width: 48pt;" width="64">G</td> <td class="xl66" style="width: 48pt;" width="64">H</td> <td class="xl66" style="width: 48pt;" width="64">I</td> <td class="xl66" style="width: 48pt;" width="64">J</td> <td class="xl66" style="width: 48pt;" width="64">K</td> <td class="xl66" style="width: 48pt;" width="64">L</td> <td class="xl63" style="width: 48pt;" width="64">M</td> <td class="xl63" style="width: 48pt;" width="64">N</td> <td class="xl63" style="width: 48pt;" width="64">O</td> <td class="xl63" style="width: 48pt;" width="64">P</td> <td class="xl63" style="width: 48pt;" width="64">Q</td> <td class="xl63" style="width: 48pt;" width="64">R</td> <td class="xl63" style="width: 48pt;" width="64">S</td> <td class="xl63" style="width: 48pt;" width="64">T</td> <td class="xl63" style="width: 48pt;" width="64">U</td> <td class="xl63" style="width: 48pt;" width="64">V</td> <td class="xl63" style="width: 48pt;" width="64">W</td> <td class="xl63" style="width: 48pt;" width="64">X</td> <td class="xl63" style="width: 48pt;" width="64">Y</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">2</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:31</td> <td class="xl67">0.60 </td> <td class="xl66">152</td> <td class="xl66">C</td> <td class="xl66">595</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">3</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:31</td> <td class="xl67">5.50 </td> <td class="xl66">89</td> <td class="xl66">C</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">Text4</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">4</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:31</td> <td class="xl67">12.00 </td> <td class="xl66">44</td> <td class="xl66">P</td> <td class="xl66">595</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">5</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:31</td> <td class="xl67">7.50 </td> <td class="xl66">2</td> <td class="xl66">P</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">Text4</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">6</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">2.00 </td> <td class="xl66">95</td> <td class="xl66">C</td> <td class="xl66">595</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">7</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">5.20 </td> <td class="xl66">123</td> <td class="xl66">C</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">8</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">2.25 </td> <td class="xl66">123</td> <td class="xl66">P</td> <td class="xl66">595</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">9</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">5.50 </td> <td class="xl66">20</td> <td class="xl66">P</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">10</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">0.75 </td> <td class="xl66">25</td> <td class="xl66">C</td> <td class="xl66">595</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">Text4</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">11</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">6.00 </td> <td class="xl66">85</td> <td class="xl66">C</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">12</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">2.05 </td> <td class="xl66">42</td> <td class="xl66">P</td> <td class="xl66">595</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">13</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">5.90 </td> <td class="xl66">3</td> <td class="xl66">P</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">14</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:31</td> <td class="xl67">0.90 </td> <td class="xl66">96</td> <td class="xl66">C</td> <td class="xl66">620</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">Text4</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">15</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:31</td> <td class="xl67">3.20 </td> <td class="xl66">49</td> <td class="xl66">C</td> <td class="xl66">615</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">16</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:31</td> <td class="xl67">9.80 </td> <td class="xl66">0</td> <td class="xl66">P</td> <td class="xl66">615</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">17</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:31</td> <td class="xl67">17.90 </td> <td class="xl66">0</td> <td class="xl66">P</td> <td class="xl66">620</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">18</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">0.85 </td> <td class="xl66">21</td> <td class="xl66">C</td> <td class="xl66">615</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">19</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">2.89 </td> <td class="xl66">4</td> <td class="xl66">C</td> <td class="xl66">620</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">20</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">2.45 </td> <td class="xl66">38</td> <td class="xl66">P</td> <td class="xl66">620</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">21</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">9.80 </td> <td class="xl66">0</td> <td class="xl66">P</td> <td class="xl66">615</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">22</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">0.85 </td> <td class="xl66">12</td> <td class="xl66">C</td> <td class="xl66">620</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">23</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">2.90 </td> <td class="xl66">6</td> <td class="xl66">C</td> <td class="xl66">615</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">24</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">7.10 </td> <td class="xl66">7</td> <td class="xl66">P</td> <td class="xl66">615</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">25</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">17.90 </td> <td class="xl66">0</td> <td class="xl66">P</td> <td class="xl66">620</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">26</td> <td class="xl66">
</td> <td class="xl68">1/5/2011</td> <td class="xl66">
</td> <td class="xl69">9:31</td> <td class="xl67">4.00 </td> <td class="xl66">32</td> <td class="xl66">C</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">27</td> <td class="xl66">
</td> <td class="xl68">1/5/2011</td> <td class="xl66">
</td> <td class="xl69">9:31</td> <td class="xl67">13.80 </td> <td class="xl66">0</td> <td class="xl66">C</td> <td class="xl66">595</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">28</td> <td class="xl66">
</td> <td class="xl68">1/5/2011</td> <td class="xl66">
</td> <td class="xl69">9:31</td> <td class="xl67">0.75 </td> <td class="xl66">10</td> <td class="xl66">P</td> <td class="xl66">595</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">29</td> <td class="xl66">
</td> <td class="xl68">1/5/2011</td> <td class="xl66">
</td> <td class="xl69">9:31</td> <td class="xl67">3.30 </td> <td class="xl66">16</td> <td class="xl66">P</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">30</td> <td class="xl66">
</td> <td class="xl68">1/5/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">1.10 </td> <td class="xl66">8</td> <td class="xl66">C</td> <td class="xl66">595</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">31</td> <td class="xl66">
</td> <td class="xl68">1/5/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">5.30 </td> <td class="xl66">19</td> <td class="xl66">C</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">Text4</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">32</td> <td class="xl66">
</td> <td class="xl68">1/5/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">2.50 </td> <td class="xl66">63</td> <td class="xl66">P</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">Text4</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">33</td> <td class="xl66">
</td> <td class="xl68">1/5/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">9.60 </td> <td class="xl66">0</td> <td class="xl66">P</td> <td class="xl66">595</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">34</td> <td class="xl66">
</td> <td class="xl68">1/5/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">4.80 </td> <td class="xl66">35</td> <td class="xl66">C</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">35</td> <td class="xl66">
</td> <td class="xl68">1/5/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">12.70 </td> <td class="xl66">0</td> <td class="xl66">C</td> <td class="xl66">595</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">36</td> <td class="xl66">
</td> <td class="xl68">1/5/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">2.85 </td> <td class="xl66">25</td> <td class="xl66">P</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">37</td> <td class="xl66">
</td> <td class="xl68">1/5/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">9.60 </td> <td class="xl66">0</td> <td class="xl66">P</td> <td class="xl66">595</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl67">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl67">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" colspan="2" style="height: 15pt;" height="20">Desired Output</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl67">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">
</td> <td class="xl66">A</td> <td class="xl66">B</td> <td class="xl66">C</td> <td class="xl67">D</td> <td class="xl66">E</td> <td class="xl66">F</td> <td class="xl66">G</td> <td class="xl66">H</td> <td class="xl66">I</td> <td class="xl66">J</td> <td class="xl66">K</td> <td class="xl66">L</td> <td class="xl63">M</td> <td class="xl63">N</td> <td class="xl63">O</td> <td class="xl63">P</td> <td class="xl63">Q</td> <td class="xl63">R</td> <td class="xl63">S</td> <td class="xl63">T</td> <td class="xl63">U</td> <td class="xl63">V</td> <td class="xl63">W</td> <td class="xl63">X</td> <td class="xl63">Y</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">3</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:31</td> <td class="xl67">5.50 </td> <td class="xl66">89</td> <td class="xl66">C</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">Text4</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">5</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:31</td> <td class="xl67">7.50 </td> <td class="xl66">2</td> <td class="xl66">P</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">Text4</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">7</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">5.20 </td> <td class="xl66">123</td> <td class="xl66">C</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">9</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">5.50 </td> <td class="xl66">20</td> <td class="xl66">P</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">11</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">6.00 </td> <td class="xl66">85</td> <td class="xl66">C</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">13</td> <td class="xl66">
</td> <td class="xl68">1/3/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">5.90 </td> <td class="xl66">3</td> <td class="xl66">P</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">14</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:31</td> <td class="xl67">0.90 </td> <td class="xl66">96</td> <td class="xl66">C</td> <td class="xl66">620</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">Text4</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">17</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:31</td> <td class="xl67">17.90 </td> <td class="xl66">0</td> <td class="xl66">P</td> <td class="xl66">620</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">19</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">2.89 </td> <td class="xl66">4</td> <td class="xl66">C</td> <td class="xl66">620</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">20</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">2.45 </td> <td class="xl66">38</td> <td class="xl66">P</td> <td class="xl66">620</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">22</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">0.85 </td> <td class="xl66">12</td> <td class="xl66">C</td> <td class="xl66">620</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">25</td> <td class="xl66">
</td> <td class="xl68">1/4/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">17.90 </td> <td class="xl66">0</td> <td class="xl66">P</td> <td class="xl66">620</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">31</td> <td class="xl66">
</td> <td class="xl68">1/5/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">5.30 </td> <td class="xl66">19</td> <td class="xl66">C</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">Text4</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">32</td> <td class="xl66">
</td> <td class="xl68">1/5/2011</td> <td class="xl66">
</td> <td class="xl69">9:33</td> <td class="xl67">2.50 </td> <td class="xl66">63</td> <td class="xl66">P</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">Text4</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">34</td> <td class="xl66">
</td> <td class="xl68">1/5/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">4.80 </td> <td class="xl66">35</td> <td class="xl66">C</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl71" style="height: 15pt;" height="20">36</td> <td class="xl66">
</td> <td class="xl68">1/5/2011</td> <td class="xl66">
</td> <td class="xl69">9:35</td> <td class="xl67">2.85 </td> <td class="xl66">25</td> <td class="xl66">P</td> <td class="xl66">600</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl64">
</td> </tr> </tbody></table>
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Sort by date Sort by votes
Hi all, after re-reading my post I can see it was more confusing than I had intended. Let me try to explain again what I’m looking for (and without having to clear or delete rows which I think might make it easier)… I am looking for a formula or macro with the desired output in Column Z. The desired output will read “Keep.” I am using Excel 2010 and all data is in order from smallest/earliest to largest/latest.

On each given date (Column B) I want the first row that has “Text4” appear in Column Y to have an output of “Keep” in Column Z. Just for reference purposes, we’ll call this row First Row Of Day.

I would like Column Z to read “Keep” for rows that have the same Date (Column B) as First Row Of Day, and same numeric value in Column H as First Row Of Day, and a >= Time* (Column D) than First Row Of Day. * Just to be clear, by “>=” time I mean, for example, 9:31 = 9:31, and 10:30 > 10:15, but 10:05 is not >= 10:10. You get the idea.

In the example below you will see that Column Z shows “Keep” for rows 3, 14, and 31 based on step one because they each were the first occurrence on a given date that had “Text4” in Column Y.

I hope this was a better attempt to explain what I’m looking for. I think it will be much easier now that I am not trying to delete/clear rows but rather just having the output “Keep” in Column Z. Thank you in advance if you are willing to help me with this. I appreciate it!

<table border="0" cellpadding="0" cellspacing="0" width="1728"><col style="width: 48pt;" width="64" span="4"> <col style="width: 48pt;" width="64"> <col style="width: 48pt;" width="64" span="22"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 48pt;" width="64" height="20">
</td> <td class="xl64" style="width: 48pt;" width="64">A</td> <td class="xl64" style="width: 48pt;" width="64">B</td> <td class="xl64" style="width: 48pt;" width="64">C</td> <td class="xl65" style="width: 48pt;" width="64">D</td> <td class="xl64" style="width: 48pt;" width="64">E</td> <td class="xl64" style="width: 48pt;" width="64">F</td> <td class="xl64" style="width: 48pt;" width="64">G</td> <td class="xl64" style="width: 48pt;" width="64">H</td> <td class="xl64" style="width: 48pt;" width="64">I</td> <td class="xl64" style="width: 48pt;" width="64">J</td> <td class="xl64" style="width: 48pt;" width="64">K</td> <td class="xl64" style="width: 48pt;" width="64">L</td> <td class="xl66" style="width: 48pt;" width="64">M</td> <td class="xl66" style="width: 48pt;" width="64">N</td> <td class="xl66" style="width: 48pt;" width="64">O</td> <td class="xl66" style="width: 48pt;" width="64">P</td> <td class="xl66" style="width: 48pt;" width="64">Q</td> <td class="xl66" style="width: 48pt;" width="64">R</td> <td class="xl66" style="width: 48pt;" width="64">S</td> <td class="xl66" style="width: 48pt;" width="64">T</td> <td class="xl66" style="width: 48pt;" width="64">U</td> <td class="xl66" style="width: 48pt;" width="64">V</td> <td class="xl66" style="width: 48pt;" width="64">W</td> <td class="xl66" style="width: 48pt;" width="64">X</td> <td class="xl66" style="width: 48pt;" width="64">Y</td> <td class="xl66" style="width: 48pt;" width="64">Z</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">2</td> <td class="xl64">
</td> <td class="xl67">1/3/2011</td> <td class="xl64">
</td> <td class="xl68">9:31</td> <td class="xl65">0.60 </td> <td class="xl64">152</td> <td class="xl64">C</td> <td class="xl64">595</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">3</td> <td class="xl64">
</td> <td class="xl67">1/3/2011</td> <td class="xl64">
</td> <td class="xl68">9:31</td> <td class="xl65">5.50 </td> <td class="xl64">89</td> <td class="xl64">C</td> <td class="xl64">600</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">Text4</td> <td class="xl66">Keep</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">4</td> <td class="xl64">
</td> <td class="xl67">1/3/2011</td> <td class="xl64">
</td> <td class="xl68">9:31</td> <td class="xl65">12.00 </td> <td class="xl64">44</td> <td class="xl64">P</td> <td class="xl64">595</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">5</td> <td class="xl64">
</td> <td class="xl67">1/3/2011</td> <td class="xl64">
</td> <td class="xl68">9:31</td> <td class="xl65">7.50 </td> <td class="xl64">2</td> <td class="xl64">P</td> <td class="xl64">600</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">Text4</td> <td class="xl66">Keep</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">6</td> <td class="xl64">
</td> <td class="xl67">1/3/2011</td> <td class="xl64">
</td> <td class="xl68">9:33</td> <td class="xl65">2.00 </td> <td class="xl64">95</td> <td class="xl64">C</td> <td class="xl64">595</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">7</td> <td class="xl64">
</td> <td class="xl67">1/3/2011</td> <td class="xl64">
</td> <td class="xl68">9:33</td> <td class="xl65">5.20 </td> <td class="xl64">123</td> <td class="xl64">C</td> <td class="xl64">600</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">Keep</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">8</td> <td class="xl64">
</td> <td class="xl67">1/3/2011</td> <td class="xl64">
</td> <td class="xl68">9:33</td> <td class="xl65">2.25 </td> <td class="xl64">123</td> <td class="xl64">P</td> <td class="xl64">595</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">9</td> <td class="xl64">
</td> <td class="xl67">1/3/2011</td> <td class="xl64">
</td> <td class="xl68">9:33</td> <td class="xl65">5.50 </td> <td class="xl64">20</td> <td class="xl64">P</td> <td class="xl64">600</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">Keep</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">10</td> <td class="xl64">
</td> <td class="xl67">1/3/2011</td> <td class="xl64">
</td> <td class="xl68">9:35</td> <td class="xl65">0.75 </td> <td class="xl64">25</td> <td class="xl64">C</td> <td class="xl64">595</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">Text4</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">11</td> <td class="xl64">
</td> <td class="xl67">1/3/2011</td> <td class="xl64">
</td> <td class="xl68">9:35</td> <td class="xl65">6.00 </td> <td class="xl64">85</td> <td class="xl64">C</td> <td class="xl64">600</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">Keep</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">12</td> <td class="xl64">
</td> <td class="xl67">1/3/2011</td> <td class="xl64">
</td> <td class="xl68">9:35</td> <td class="xl65">2.05 </td> <td class="xl64">42</td> <td class="xl64">P</td> <td class="xl64">595</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">13</td> <td class="xl64">
</td> <td class="xl67">1/3/2011</td> <td class="xl64">
</td> <td class="xl68">9:35</td> <td class="xl65">5.90 </td> <td class="xl64">3</td> <td class="xl64">P</td> <td class="xl64">600</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">Keep</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">14</td> <td class="xl64">
</td> <td class="xl67">1/4/2011</td> <td class="xl64">
</td> <td class="xl68">9:31</td> <td class="xl65">0.90 </td> <td class="xl64">96</td> <td class="xl64">C</td> <td class="xl64">620</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">Text4</td> <td class="xl66">Keep</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">15</td> <td class="xl64">
</td> <td class="xl67">1/4/2011</td> <td class="xl64">
</td> <td class="xl68">9:31</td> <td class="xl65">3.20 </td> <td class="xl64">49</td> <td class="xl64">C</td> <td class="xl64">615</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">16</td> <td class="xl64">
</td> <td class="xl67">1/4/2011</td> <td class="xl64">
</td> <td class="xl68">9:31</td> <td class="xl65">9.80 </td> <td class="xl64">0</td> <td class="xl64">P</td> <td class="xl64">615</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">17</td> <td class="xl64">
</td> <td class="xl67">1/4/2011</td> <td class="xl64">
</td> <td class="xl68">9:31</td> <td class="xl65">17.90 </td> <td class="xl64">0</td> <td class="xl64">P</td> <td class="xl64">620</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">Keep</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">18</td> <td class="xl64">
</td> <td class="xl67">1/4/2011</td> <td class="xl64">
</td> <td class="xl68">9:33</td> <td class="xl65">0.85 </td> <td class="xl64">21</td> <td class="xl64">C</td> <td class="xl64">615</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">19</td> <td class="xl64">
</td> <td class="xl67">1/4/2011</td> <td class="xl64">
</td> <td class="xl68">9:33</td> <td class="xl65">2.89 </td> <td class="xl64">4</td> <td class="xl64">C</td> <td class="xl64">620</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">Keep</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">20</td> <td class="xl64">
</td> <td class="xl67">1/4/2011</td> <td class="xl64">
</td> <td class="xl68">9:33</td> <td class="xl65">2.45 </td> <td class="xl64">38</td> <td class="xl64">P</td> <td class="xl64">620</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">Keep</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">21</td> <td class="xl64">
</td> <td class="xl67">1/4/2011</td> <td class="xl64">
</td> <td class="xl68">9:33</td> <td class="xl65">9.80 </td> <td class="xl64">0</td> <td class="xl64">P</td> <td class="xl64">615</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">22</td> <td class="xl64">
</td> <td class="xl67">1/4/2011</td> <td class="xl64">
</td> <td class="xl68">9:35</td> <td class="xl65">0.85 </td> <td class="xl64">12</td> <td class="xl64">C</td> <td class="xl64">620</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">Keep</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">23</td> <td class="xl64">
</td> <td class="xl67">1/4/2011</td> <td class="xl64">
</td> <td class="xl68">9:35</td> <td class="xl65">2.90 </td> <td class="xl64">6</td> <td class="xl64">C</td> <td class="xl64">615</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">24</td> <td class="xl64">
</td> <td class="xl67">1/4/2011</td> <td class="xl64">
</td> <td class="xl68">9:35</td> <td class="xl65">7.10 </td> <td class="xl64">7</td> <td class="xl64">P</td> <td class="xl64">615</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">25</td> <td class="xl64">
</td> <td class="xl67">1/4/2011</td> <td class="xl64">
</td> <td class="xl68">9:35</td> <td class="xl65">17.90 </td> <td class="xl64">0</td> <td class="xl64">P</td> <td class="xl64">620</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">Keep</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">26</td> <td class="xl64">
</td> <td class="xl67">1/5/2011</td> <td class="xl64">
</td> <td class="xl68">9:31</td> <td class="xl65">4.00 </td> <td class="xl64">32</td> <td class="xl64">C</td> <td class="xl64">600</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">27</td> <td class="xl64">
</td> <td class="xl67">1/5/2011</td> <td class="xl64">
</td> <td class="xl68">9:31</td> <td class="xl65">13.80 </td> <td class="xl64">0</td> <td class="xl64">C</td> <td class="xl64">595</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">28</td> <td class="xl64">
</td> <td class="xl67">1/5/2011</td> <td class="xl64">
</td> <td class="xl68">9:31</td> <td class="xl65">0.75 </td> <td class="xl64">10</td> <td class="xl64">P</td> <td class="xl64">595</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">29</td> <td class="xl64">
</td> <td class="xl67">1/5/2011</td> <td class="xl64">
</td> <td class="xl68">9:31</td> <td class="xl65">3.30 </td> <td class="xl64">16</td> <td class="xl64">P</td> <td class="xl64">600</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">30</td> <td class="xl64">
</td> <td class="xl67">1/5/2011</td> <td class="xl64">
</td> <td class="xl68">9:33</td> <td class="xl65">1.10 </td> <td class="xl64">8</td> <td class="xl64">C</td> <td class="xl64">595</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">31</td> <td class="xl64">
</td> <td class="xl67">1/5/2011</td> <td class="xl64">
</td> <td class="xl68">9:33</td> <td class="xl65">5.30 </td> <td class="xl64">19</td> <td class="xl64">C</td> <td class="xl64">600</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">Text4</td> <td class="xl66">Keep</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">32</td> <td class="xl64">
</td> <td class="xl67">1/5/2011</td> <td class="xl64">
</td> <td class="xl68">9:33</td> <td class="xl65">2.50 </td> <td class="xl64">63</td> <td class="xl64">P</td> <td class="xl64">600</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">Text4</td> <td class="xl66">Keep</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">33</td> <td class="xl64">
</td> <td class="xl67">1/5/2011</td> <td class="xl64">
</td> <td class="xl68">9:33</td> <td class="xl65">9.60 </td> <td class="xl64">0</td> <td class="xl64">P</td> <td class="xl64">595</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">34</td> <td class="xl64">
</td> <td class="xl67">1/5/2011</td> <td class="xl64">
</td> <td class="xl68">9:35</td> <td class="xl65">4.80 </td> <td class="xl64">35</td> <td class="xl64">C</td> <td class="xl64">600</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">Keep</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">35</td> <td class="xl64">
</td> <td class="xl67">1/5/2011</td> <td class="xl64">
</td> <td class="xl68">9:35</td> <td class="xl65">12.70 </td> <td class="xl64">0</td> <td class="xl64">C</td> <td class="xl64">595</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">36</td> <td class="xl64">
</td> <td class="xl67">1/5/2011</td> <td class="xl64">
</td> <td class="xl68">9:35</td> <td class="xl65">2.85 </td> <td class="xl64">25</td> <td class="xl64">P</td> <td class="xl64">600</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">Keep</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">37</td> <td class="xl64">
</td> <td class="xl67">1/5/2011</td> <td class="xl64">
</td> <td class="xl68">9:35</td> <td class="xl65">9.60 </td> <td class="xl64">0</td> <td class="xl64">P</td> <td class="xl64">595</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl64">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl66">
</td> <td class="xl69">
</td> <td class="xl66">
</td> </tr> </tbody></table>
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

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
F
  • Question
Time Percentages
Replies
1
Views
791
James006
James006
G
  • Question
copy/paster to another worksheet
Replies
5
Views
639
Fluff
Fluff
D
  • Question
Sales from days of this month vs same quantity of days same month last year.
Replies
2
Views
1K
Daniboy
D

Forum statistics

Threads
1,215,223
Messages
6,123,715
Members
449,118
Latest member
MichealRed

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