=COUNTIFS Help

Quesenbarrett

New Member
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.
Can you post some sample data and the desired output?

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.

<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.

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.

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.

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.

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.

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.

YOU'RE A GENIUS!!
It works!! Thank you very much!!

You are welcome and thanks for the feedback!

M.

Replies
3
Views
190
Replies
4
Views
93
Replies
5
Views
98
Replies
1
Views
168
Replies
1
Views
116

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

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.

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

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