=COUNTIFS Help

Q

Quesenbarrett

New Member
Joined
Mar 28, 2008
Messages
16
I have the following formula to calculate how many reps are over goal in a period =COUNTIFS(C8:S8,">1.00") Which works fine...

EXCEPT what I really want to calculate is the number of CONSECUTIVE months over goal.

Help!
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Sort by date Sort by votes
Assuming C8:S8 as

<TABLE style="WIDTH: 510pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=680><COLGROUP><COL style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 1462" span=17 width=40><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 30pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=20 width=40 align=right>0,5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=40 align=right>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=40 align=right>1,1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=40 align=right>0,8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=40 align=right>1,3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=40 align=right>1,4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=40 align=right>1,7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=40 align=right>0,5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=40 align=right>0,3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; WIDTH: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=40 align=right>1,4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; WIDTH: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=40 align=right>1,5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; WIDTH: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=40 align=right>1,7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; WIDTH: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=40 align=right>1,8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=40 align=right>0,7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=40 align=right>0,9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=40 align=right>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=40 align=right>1,9</TD></TR></TBODY></TABLE>

The array formula below returns 4, ie the MAX of consecutive months over goal (1,0)

=MAX(FREQUENCY(IF(C8:S8>1,COLUMN(C8:S8)),IF(C8:S8<=1,COLUMN(C8:S8))))

confirmed with Ctrl+Shift+Enter
(hold down both Ctrl and Shift keys and hit Enter)

M.
 
Upvote 0
<TABLE style="WIDTH: 514pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=689 border=0><COLGROUP><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 2011" span=11 width=55><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><TBODY><TR style="HEIGHT: 51.75pt" height=69><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 41pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 51.75pt; BACKGROUND-COLOR: #99ccff" width=55 height=69>Jul-11</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 41pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff" width=55>Aug-11</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 41pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff" width=55>Sep-11</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 41pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff" width=55>Oct-11</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 41pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff" width=55>Nov-11</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 41pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff" width=55>Dec-11</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 41pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff" width=55>Jan-12</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 41pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff" width=55>Feb-12</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 41pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff" width=55>Mar-12</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 41pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff" width=55>Apr-12</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 41pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff" width=55>May-12</TD><TD class=xl104 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 63pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff" width=84># of Consecutive Months over Goal</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; mso-pattern: black none" height=17></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>161.6%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>164.8%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>168.9%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>200.5%</TD><TD class=xl106 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; mso-pattern: black none" align=right height=17>85.5%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>90.3%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>41.4%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>44.4%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>63.0%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>41.4%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>50.3%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>45.3%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>42.1%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>62.8%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>50.2%</TD><TD class=xl106 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; mso-pattern: black none" height=17></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>113.2%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>64.5%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>88.4%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>83.9%</TD><TD class=xl106 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; mso-pattern: black none" align=right height=17>113.6%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>114.7%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>87.7%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>97.3%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>95.6%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>96.4%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>103.3%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>118.4%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>101.2%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>96.9%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>115.2%</TD><TD class=xl106 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; mso-pattern: black none" height=17></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>82.7%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>82.5%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>82.6%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>87.5%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>91.7%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>119.2%</TD><TD class=xl106 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">1</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; mso-pattern: black none" height=18></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>105.0%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>100.9%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>101.6%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>110.8%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>104.1%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>113.5%</TD><TD class=xl106 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">6</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl108 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Arial; HEIGHT: 20.25pt; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right height=27>146.6%</TD><TD class=xl108 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>130.5%</TD><TD class=xl108 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>114.2%</TD><TD class=xl108 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>364.2%</TD><TD class=xl108 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>106.8%</TD><TD class=xl108 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>110.2%</TD><TD class=xl108 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>159.8%</TD><TD class=xl108 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>147.4%</TD><TD class=xl108 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>183.8%</TD><TD class=xl108 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>141.8%</TD><TD class=xl108 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: windowtext 1pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>198.1%</TD><TD class=xl109 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; mso-pattern: black none" align=right height=17>85.4%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>110.2%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>108.6%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>101.6%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>94.5%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>142.7%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>121.7%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>104.8%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>86.5%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>156.9%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>84.5%</TD><TD class=xl106 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; mso-pattern: black none" align=right height=17>252.1%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>92.1%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>67.6%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>76.8%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>263.1%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>96.6%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>99.5%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>107.6%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>95.1%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>54.7%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>98.8%</TD><TD class=xl106 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; mso-pattern: black none" align=right height=17>93.8%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>96.9%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>96.8%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>120.9%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>131.3%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>71.9%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>132.5%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>120.1%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>138.5%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>65.1%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>88.9%</TD><TD class=xl106 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; mso-pattern: black none" align=right height=17>89.5%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>80.9%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>128.8%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>122.9%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>83.0%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>100.6%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>112.4%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>95.6%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>92.7%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>112.2%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>136.6%</TD><TD class=xl106 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; mso-pattern: black none" align=right height=17>82.3%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>196.2%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>66.4%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>95.3%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>115.3%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>92.8%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>116.0%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>119.8%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>85.1%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>173.0%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>56.6%</TD><TD class=xl106 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; mso-pattern: black none" align=right height=17>125.5%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>112.6%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>97.2%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>141.9%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>113.7%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>129.3%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>183.7%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>179.0%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>154.6%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>93.7%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>102.0%</TD><TD class=xl106 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; mso-pattern: black none" align=right height=17>96.7%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>146.8%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>101.3%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>107.9%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>81.5%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>146.4%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>122.1%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>91.8%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>97.7%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>102.5%</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>142.6%</TD><TD class=xl106 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">2</TD></TR></TBODY></TABLE>

Right now I'm figuring this manually; would perfer a formula that will calculate the number of months consecutively over goal. Hope the above table helps.
 
Upvote 0
So I could probably combine your =MAX(FREQUENCY formula with an =IF formula to look at the latest month and if under goal than stop counting?

Hmmm? I'll try that.
 
Upvote 0
Quesenbarrett said:
So I could probably combine your =MAX(FREQUENCY formula with an =IF formula to look at the latest month and if under goal than stop counting?

Hmmm? I'll try that.
Click to expand...

What are the expected results using your data sample in #4? I'm not understanding why, for example, 1 in the 4th row and 2 in the last row. Could you clarify?

M.
 
Upvote 0
Ok...I switched the layout. What I want is for the formula to look at the percentage in cell D2 and if =>100% to count the consecutive times over goal. If there is break (like in row 5) it would stop counting. The results I want are showing in Column C.

<TABLE style="WIDTH: 537pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=719 border=0><COLGROUP><COL style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 1097" width=30><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 2011" span=11 width=55><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 23pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=30 height=18></TD><TD class=xl110 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 63pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=84>C</TD><TD class=xl110 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 41pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=55>D</TD><TD class=xl110 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 41pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=55>E</TD><TD class=xl110 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 41pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=55>F</TD><TD class=xl110 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 41pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=55>G</TD><TD class=xl110 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 41pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=55>H</TD><TD class=xl110 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 41pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=55>I</TD><TD class=xl110 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 41pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=55>J</TD><TD class=xl110 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 41pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=55>K</TD><TD class=xl110 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 41pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=55>L</TD><TD class=xl110 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 41pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=55>M</TD><TD class=xl110 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 41pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=55>N</TD></TR><TR style="HEIGHT: 64.5pt" height=86><TD class=xl111 id=td_post_3179020 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 64.5pt; BACKGROUND-COLOR: transparent" height=86>1</TD><TD class=xl109 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 63pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff" width=84># of Consecutive Months over Goal RESULTS</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff">May-12</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff">Apr-12</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff">Mar-12</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff">Feb-12</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff">Jan-12</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff">Dec-11</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff">Nov-11</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff">Oct-11</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff">Sep-11</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff">Aug-11</TD><TD class=xl103 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #99ccff">Jul-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl111 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>2</TD><TD class=xl108 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">4</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>200.5%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>168.9%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>164.8%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>161.6%</TD><TD class=xl107 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl107 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl107 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl107 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl107 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl107 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl107 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl111 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>3</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>50.2%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>62.8%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>42.1%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>45.3%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>50.3%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>41.4%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>63.0%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>44.4%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>41.4%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>90.3%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>85.5%</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl111 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>4</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>83.9%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>88.4%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>64.5%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>113.2%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl111 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>5</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">1</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>115.2%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>96.9%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>101.2%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>118.4%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>103.3%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>96.4%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>95.6%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>97.3%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>87.7%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>114.7%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>113.6%</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl111 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>6</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">1</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>119.2%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>91.7%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>87.5%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>82.6%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>82.5%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>82.7%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl111 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>7</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">6</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>113.5%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>104.1%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>110.8%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>101.6%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>100.9%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>105.0%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none"></TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl111 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent" height=27>8</TD><TD class=xl113 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">11</TD><TD class=xl112 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>198.1%</TD><TD class=xl112 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>141.8%</TD><TD class=xl112 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>183.8%</TD><TD class=xl112 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>147.4%</TD><TD class=xl112 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>159.8%</TD><TD class=xl112 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>110.2%</TD><TD class=xl112 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>106.8%</TD><TD class=xl112 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>364.2%</TD><TD class=xl112 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>114.2%</TD><TD class=xl112 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>130.5%</TD><TD class=xl112 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" align=right>146.6%</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl111 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>9</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>84.5%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>156.9%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>86.5%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>104.8%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>121.7%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>142.7%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>94.5%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>101.6%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>108.6%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>110.2%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>85.4%</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl111 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>10</TD><TD class=xl105 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>98.8%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>54.7%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>95.1%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>107.6%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>99.5%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>96.6%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>263.1%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>76.8%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>67.6%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #dce6f1; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>92.1%</TD><TD class=xl104 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BACKGROUND: #ffff66; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; mso-pattern: black none" align=right>252.1%</TD></TR></TBODY></TABLE>
I tried the MAX formula but didn't work.
I hope I'm clear about the results I want.
Thanks for your help!!
 
Upvote 0
Try this array formula in C2

=MATCH(0,IF($D2:$AZ2<1,0),0)-1

confirmed with Ctrl+Shift+Enter
(hold down both Ctrl and Shift keys and hit Enter)

copy down

M.
 
Upvote 0
You must log in or register to reply here.

Similar threads

F
  • Question
About to Lose my mind
Replies
3
Views
190
iggydarsa
iggydarsa
A
  • Solved
Goal Seek without using Goal Seek
Replies
4
Views
93
aquelious
A
J
  • Question
Complicated (for me) countifs function
Replies
5
Views
98
Fluff
Fluff
P
  • Question
Monthly Growth Rates
Replies
1
Views
168
Skybluekid
Skybluekid
J
  • Question
COUNTIFS and COUNTIF in a Sharepoint spreadsheet returning #VALUE!
Replies
1
Views
116
jason7579
J

Forum statistics

Threads
1,203,617
Messages
6,056,310
Members
444,858
Latest member
ucbphd

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