Need help with a three variable lookup

clhmms

New Member
Joined
Aug 23, 2011
Messages
22
<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </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-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> Hello all,

I am trying unsuccessfully to use the SumProduct formula with 3 arrays. For example, the user will enter data in the “Group” and the “YrMo” fields and excel will populate the rates for A, B, C, D and E. I am not sure what I am doing wrong because I am getting “#VALUE!”. Is it my SumProduct syntax? Should I use a different formula because I actually don’t need to calculate anything I just need the rate?


These are the formulas I have tried
=SUMPRODUCT(--($C$2:$N$2=$Q$1),--(B3:B95=$Q$2),--($A$3:$A$95=P7),$C$3:$N$95)
=SUMPRODUCT(($C$2:$N$2=$Q$1),(B4:B96=$Q$2),($A$3:$A$95=P8),$C$3:$N$95)



Below is my table
<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </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-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> <table class="MsoNormalTable" style="width: 499.4pt; margin-left: 5.4pt; border-collapse: collapse;" width="666" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(204, 204, 255); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap">
</td> <td style="width: 61.8pt; background: none repeat scroll 0% 0% rgb(204, 204, 255); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
</td> <td style="width: 34.8pt; background: none repeat scroll 0% 0% rgb(204, 204, 255); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap"> Group
</td> <td style="width: 34.8pt; background: none repeat scroll 0% 0% rgb(204, 204, 255); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
</td> <td style="width: 40.8pt; background: none repeat scroll 0% 0% rgb(204, 204, 255); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
</td> <td style="width: 40.8pt; background: none repeat scroll 0% 0% rgb(204, 204, 255); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
</td> <td style="width: 40.8pt; background: none repeat scroll 0% 0% rgb(204, 204, 255); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
</td> <td style="width: 59pt; border: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap"> Enter Group
</td> <td style="width: 60pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
9
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(0, 102, 204); background: none repeat scroll 0% 0% rgb(204, 204, 255); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> Ltr
</td> <td style="width: 61.8pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(0, 102, 204); background: none repeat scroll 0% 0% rgb(204, 204, 255); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap"> YrMo
</td> <td style="width: 34.8pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(0, 102, 204); background: none repeat scroll 0% 0% rgb(204, 204, 255); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
8
</td> <td style="width: 34.8pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(0, 102, 204); background: none repeat scroll 0% 0% rgb(204, 204, 255); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
9
</td> <td style="width: 40.8pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(0, 102, 204); background: none repeat scroll 0% 0% rgb(204, 204, 255); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
10
</td> <td style="width: 40.8pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(0, 102, 204); background: none repeat scroll 0% 0% rgb(204, 204, 255); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
11
</td> <td style="width: 40.8pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(0, 102, 204); background: none repeat scroll 0% 0% rgb(204, 204, 255); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
12
</td> <td style="width: 59pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap"> Enter YrMo
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
200910
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
200910
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
7.1%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
7.7%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
8.4%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
9.0%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
9.6%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
200911
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
7.4%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
8.1%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
8.8%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
9.4%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
10.0%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
200912
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
7.3%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
8.0%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
8.6%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
9.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
9.8%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15.75pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15.75pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15.75pt;" valign="bottom" width="82" nowrap="nowrap">
201001
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15.75pt;" valign="bottom" width="46" nowrap="nowrap">
7.2%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15.75pt;" valign="bottom" width="46" nowrap="nowrap">
7.8%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15.75pt;" valign="bottom" width="54" nowrap="nowrap">
8.4%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15.75pt;" valign="bottom" width="54" nowrap="nowrap">
9.1%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15.75pt;" valign="bottom" width="54" nowrap="nowrap">
9.7%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15.75pt;" valign="bottom" width="79" nowrap="nowrap"> Ltr
</td> <td style="width: 60pt; border-width: 1pt medium; border-style: solid none; border-color: windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15.75pt;" valign="bottom" width="80" nowrap="nowrap">
Rate %
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15.75pt;" valign="bottom" width="103" nowrap="nowrap"> Expected result
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201002
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
8.4%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
9.1%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
9.9%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
10.6%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
11.3%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap"> A
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
#VALUE!
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
7.70%
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201003
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
7.5%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
8.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
8.9%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
9.6%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
10.3%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap"> B
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
#VALUE!
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
68.00%
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201004
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
7.6%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
8.4%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
9.1%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
9.8%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
10.5%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201005
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
8.1%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
8.9%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
9.7%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
10.4%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
11.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201006
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
8.5%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
9.4%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
10.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
11.0%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
11.7%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201007
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
8.7%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
9.6%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
10.4%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
11.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
12.0%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201008
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
8.5%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
9.4%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
10.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
11.0%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201009
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
9.3%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
10.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
11.1%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201010
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
9.4%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
10.3%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201011
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
10.3%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201012
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201101
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201102
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201103
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201104
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201105
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> A
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201106
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
200910
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
61.5%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
68.0%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
74.7%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
81.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
87.4%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
200911
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
66.6%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
73.9%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
81.0%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
87.8%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
94.3%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
200912
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
65.8%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
72.8%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
79.7%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
86.1%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
93.0%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201001
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
69.0%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
76.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
83.1%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
90.4%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
97.6%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201002
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
79.8%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
88.0%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
96.8%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
105.7%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
113.6%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201003
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
78.4%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
87.3%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
96.6%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
105.0%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
114.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201004
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
80.8%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
90.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
99.0%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
108.7%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
117.0%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201005
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
81.6%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
90.4%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
100.5%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
109.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
118.4%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201006
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
81.4%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
91.5%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
100.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
109.4%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
118.3%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201007
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
83.5%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
92.4%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
101.9%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
111.1%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
120.1%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201008
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
79.8%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
89.0%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
97.9%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
106.6%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201009
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
84.2%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
93.8%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
103.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201010
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
86.7%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
96.3%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201011
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
89.8%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201012
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201101
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201102
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 19.8pt; background: none repeat scroll 0% 0% rgb(153, 204, 0); padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="26" nowrap="nowrap"> B
</td> <td style="width: 61.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="82" nowrap="nowrap">
201103
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 34.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="46" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 40.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="54" nowrap="nowrap">
-0.2%
</td> <td style="width: 59pt; padding: 0in 5.4pt; height: 15pt;" width="79" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 77pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="103" nowrap="nowrap">
</td> </tr> </tbody></table>

Does anyone have any suggestions?

Thank you in advance for your assistance!
Cassandra:confused:
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Excel Workbook
ABCDEFGHIJ
1GroupEnter Group9
2LtrYrMo89101112Enter YrMo200910
3A2009107.10%7.70%8.40%9.00%9.60%
4A2009117.40%8.10%8.80%9.40%10.00%
5A2009127.30%8.00%8.60%9.20%9.80%
6A2010017.20%7.80%8.40%9.10%9.70%LtrRate %Expected result
7A2010028.40%9.10%9.90%10.60%11.30%A7.70%7.70%
8A2010037.50%8.20%8.90%9.60%10.30%B68.00%68.00%
9A2010047.60%8.40%9.10%9.80%10.50%
10A2010058.10%8.90%9.70%10.40%11.20%
11A2010068.50%9.40%10.20%11.00%11.70%
12A2010078.70%9.60%10.40%11.20%12.00%
13A2010088.50%9.40%10.20%11.00%-0.20%
14A2010099.30%10.20%11.10%-0.20%-0.20%
15A2010109.40%10.30%-0.20%-0.20%-0.20%
16A20101110.30%-0.20%-0.20%-0.20%-0.20%
17A201012-0.20%-0.20%-0.20%-0.20%-0.20%
18A201101-0.20%-0.20%-0.20%-0.20%-0.20%
19A201102-0.20%-0.20%-0.20%-0.20%-0.20%
20A201103-0.20%-0.20%-0.20%-0.20%-0.20%
21A201104-0.20%-0.20%-0.20%-0.20%-0.20%
22A201105-0.20%-0.20%-0.20%-0.20%-0.20%
23A201106-0.20%-0.20%-0.20%-0.20%-0.20%
24B20091061.50%68.00%74.70%81.20%87.40%
25B20091166.60%73.90%81.00%87.80%94.30%
26B20091265.80%72.80%79.70%86.10%93.00%
27B20100169.00%76.20%83.10%90.40%97.60%
28B20100279.80%88.00%96.80%105.70%113.60%
29B20100378.40%87.30%96.60%105.00%114.20%
30B20100480.80%90.20%99.00%108.70%117.00%
31B20100581.60%90.40%100.50%109.20%118.40%
32B20100681.40%91.50%100.20%109.40%118.30%
33B20100783.50%92.40%101.90%111.10%120.10%
34B20100879.80%89.00%97.90%106.60%-0.20%
35B20100984.20%93.80%103.20%-0.20%-0.20%
36B20101086.70%96.30%-0.20%-0.20%-0.20%
37B20101189.80%-0.20%-0.20%-0.20%-0.20%
38B201012-0.20%-0.20%-0.20%-0.20%-0.20%
39B201101-0.20%-0.20%-0.20%-0.20%-0.20%
40B201102-0.20%-0.20%-0.20%-0.20%-0.20%
41B201103-0.20%-0.20%-0.20%-0.20%-0.20%
Sheet1 (2)
 
Upvote 0
Thank you so much! I have never used index before.

I will do something nice for someone today because you did something nice for me :biggrin:
 
Upvote 0

Forum statistics

Threads
1,223,231
Messages
6,170,884
Members
452,364
Latest member
springate

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