Count Until?

M

mcgumby

New Member
Joined
Sep 28, 2005
Messages
9
I have a row of figures for the last 12 weeks, they are results. I need to count backwards from the most recent week, checking if the result reached target.

This is so I can show how many consecutive weeks a target has been reached.

I've toyed with the idea of a macro to do this, however as we may need to add more weeks I'd rather do it with a formulae?

I know there is countif, however this wont do it consecutively?

Has anyone any pointers?

Thanks.
 
Sort by date Sort by votes
Dom this works great, and I'm starting to understand how it all works. If however the most recent week has a measure marked "n/a" then it falls over.

Any ideas?

McG
 
Upvote 0

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Can you post about 5 rows of data representing the different scenarios possible, along with your expected results?
 
Upvote 0
I hope this isnt too many lines. Basically it is doing what it should do, however the ND or n/a fields are causing me problems. I really want it to ignore the ND results completley, ie not count them. In lines 498 and 499 everything falls over because of them.

<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=16><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - New CSCO Report.xls</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: 11.0 : OS = Windows XP </FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=16><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD vAlign=center align=right><FORM name=formCb755237><INPUT onclick='window.clipboardData.setData("Text",document.formFb078704.sltNb935705.value);' type=button value="Copy Formula" name=btCb873980></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=16><TABLE border=0><TBODY><TR><FORM name=formFb078704><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value" name=sltNb935705><OPTION value="='Graph Data'!B$25" selected>D495<OPTION value="='Graph Data'!C$25">E495<OPTION value="='Graph Data'!D$25">F495<OPTION value="='Graph Data'!E$25">G495<OPTION value="='Graph Data'!F$25">H495<OPTION value="='Graph Data'!G$25">I495<OPTION value="='Graph Data'!H$25">J495<OPTION value="='Graph Data'!I$25">K495<OPTION value="='Graph Data'!J$25">L495<OPTION value="='Graph Data'!K$25">M495<OPTION value="='Graph Data'!L$25">N495<OPTION value="='Graph Data'!M$25">O495<OPTION value="='Graph Data'!N$25">P495<OPTION value="='Graph Data'!B38">D496<OPTION value="='Graph Data'!C38">E496<OPTION value="='Graph Data'!D38">F496<OPTION value="='Graph Data'!E38">G496<OPTION value="='Graph Data'!F38">H496<OPTION value="='Graph Data'!G38">I496<OPTION value="='Graph Data'!H38">J496<OPTION value="='Graph Data'!I38">K496<OPTION value="='Graph Data'!J38">L496<OPTION value="='Graph Data'!K38">M496<OPTION value="='Graph Data'!L38">N496<OPTION value="='Graph Data'!M38">O496<OPTION value="='Graph Data'!N38">P496<OPTION value='=IF(OR(P496="n/a",P496="ND"),0,IF(COUNTIF(D496:P496,"<"&B496),MATCH(TRUE,Array3,0)-1,COUNTIF(D496:P496,OR("N/A","ND"))+COUNT(D496:P496)))'>Q496<OPTION value='{=IF(COUNTIF(D496:P496,">"&0.51),MATCH(TRUE,SUBTOTAL(9,OFFSET(D496:P496,,LARGE(IF(D496:P496<>"",COLUMN(D496:P496)-COLUMN(D496)),ROW(INDIRECT("1:"&COLUMNS(D496:P496)))),,1))>0.51,0)-1,COUNT(D496:P496))}'>R496<OPTION value="='Graph Data'!B62">D497<OPTION value="='Graph Data'!C62">E497<OPTION value="='Graph Data'!D62">F497<OPTION value="='Graph Data'!E62">G497<OPTION value="='Graph Data'!F62">H497<OPTION value="='Graph Data'!G62">I497<OPTION value="='Graph Data'!H62">J497<OPTION value="='Graph Data'!I62">K497<OPTION value="='Graph Data'!J62">L497<OPTION value="='Graph Data'!K62">M497<OPTION value="='Graph Data'!L62">N497<OPTION value="='Graph Data'!M62">O497<OPTION value="='Graph Data'!N62">P497<OPTION value='=IF(OR(P497="n/a",P497="ND"),0,IF(COUNTIF(D497:P497,"<"&B497),MATCH(TRUE,Array3,0)-1,COUNTIF(D497:P497,OR("N/A","ND"))+COUNT(D497:P497)))'>Q497<OPTION value='{=IF(COUNTIF(D497:P497,">"&0.51),MATCH(TRUE,SUBTOTAL(9,OFFSET(D497:P497,,LARGE(IF(D497:P497<>"",COLUMN(D497:P497)-COLUMN(D497)),ROW(INDIRECT("1:"&COLUMNS(D497:P497)))),,1))>0.51,0)-1,COUNT(D497:P497))}'>R497<OPTION value="='Graph Data'!B86">D498<OPTION value="='Graph Data'!C86">E498<OPTION value="='Graph Data'!D86">F498<OPTION value="='Graph Data'!E86">G498<OPTION value="='Graph Data'!F86">H498<OPTION value="='Graph Data'!G86">I498<OPTION value="='Graph Data'!H86">J498<OPTION value="='Graph Data'!I86">K498<OPTION value="='Graph Data'!J86">L498<OPTION value="='Graph Data'!K86">M498<OPTION value="='Graph Data'!L86">N498<OPTION value="='Graph Data'!M86">O498<OPTION value="='Graph Data'!N86">P498<OPTION value='=IF(OR(P498="n/a",P498="ND"),0,IF(COUNTIF(D498:P498,"<"&B498),MATCH(TRUE,Array3,0)-1,COUNTIF(D498:P498,OR("N/A","ND"))+COUNT(D498:P498)))'>Q498<OPTION value='{=IF(COUNTIF(D498:P498,">"&0.51),MATCH(TRUE,SUBTOTAL(9,OFFSET(D498:P498,,LARGE(IF(D498:P498<>"",COLUMN(D498:P498)-COLUMN(D498)),ROW(INDIRECT("1:"&COLUMNS(D498:P498)))),,1))>0.51,0)-1,COUNT(D498:P498))}'>R498<OPTION value="='Graph Data'!B110">D499<OPTION value="='Graph Data'!C110">E499<OPTION value="='Graph Data'!D110">F499<OPTION value="='Graph Data'!E110">G499<OPTION value="='Graph Data'!F110">H499<OPTION value="='Graph Data'!G110">I499<OPTION value="='Graph Data'!H110">J499<OPTION value="='Graph Data'!I110">K499<OPTION value="='Graph Data'!J110">L499<OPTION value="='Graph Data'!K110">M499<OPTION value="='Graph Data'!L110">N499<OPTION value="='Graph Data'!M110">O499<OPTION value="='Graph Data'!N110">P499<OPTION value='=IF(OR(P499="n/a",P499="ND"),0,IF(COUNTIF(D499:P499,"<"&B499),MATCH(TRUE,Array3,0)-1,COUNTIF(D499:P499,OR("N/A","ND"))+COUNT(D499:P499)))'>Q499<OPTION value='{=IF(COUNTIF(D499:P499,">"&0.51),MATCH(TRUE,SUBTOTAL(9,OFFSET(D499:P499,,LARGE(IF(D499:P499<>"",COLUMN(D499:P499)-COLUMN(D499)),ROW(INDIRECT("1:"&COLUMNS(D499:P499)))),,1))>0.51,0)-1,COUNT(D499:P499))}'>R499<OPTION value="='Graph Data'!B134">D500<OPTION value="='Graph Data'!C134">E500<OPTION value="='Graph Data'!D134">F500<OPTION value="='Graph Data'!E134">G500<OPTION value="='Graph Data'!F134">H500<OPTION value="='Graph Data'!G134">I500<OPTION value="='Graph Data'!H134">J500<OPTION value="='Graph Data'!I134">K500<OPTION value="='Graph Data'!J134">L500<OPTION value="='Graph Data'!K134">M500<OPTION value="='Graph Data'!L134">N500<OPTION value="='Graph Data'!M134">O500<OPTION value="='Graph Data'!N134">P500<OPTION value='=IF(OR(P500="n/a",P500="ND"),0,IF(COUNTIF(D500:P500,"<"&B500),MATCH(TRUE,Array3,0)-1,COUNTIF(D500:P500,OR("N/A","ND"))+COUNT(D500:P500)))'>Q500<OPTION value='{=IF(COUNTIF(D500:P500,">"&0.51),MATCH(TRUE,SUBTOTAL(9,OFFSET(D500:P500,,LARGE(IF(D500:P500<>"",COLUMN(D500:P500)-COLUMN(D500)),ROW(INDIRECT("1:"&COLUMNS(D500:P500)))),,1))>0.51,0)-1,COUNT(D500:P500))}'>R500<OPTION value="='Graph Data'!B158">D501<OPTION value="='Graph Data'!C158">E501<OPTION value="='Graph Data'!D158">F501<OPTION value="='Graph Data'!E158">G501<OPTION value="='Graph Data'!F158">H501<OPTION value="='Graph Data'!G158">I501<OPTION value="='Graph Data'!H158">J501<OPTION value="='Graph Data'!I158">K501<OPTION value="='Graph Data'!J158">L501<OPTION value="='Graph Data'!K158">M501<OPTION value="='Graph Data'!L158">N501<OPTION value="='Graph Data'!M158">O501<OPTION value="='Graph Data'!N158">P501<OPTION value="='Graph Data'!B182">D502<OPTION value="='Graph Data'!C182">E502<OPTION value="='Graph Data'!D182">F502<OPTION value="='Graph Data'!E182">G502<OPTION value="='Graph Data'!F182">H502<OPTION value="='Graph Data'!G182">I502<OPTION value="='Graph Data'!H182">J502<OPTION value="='Graph Data'!I182">K502<OPTION value="='Graph Data'!J182">L502<OPTION value="='Graph Data'!K182">M502<OPTION value="='Graph Data'!L182">N502<OPTION value="='Graph Data'!M182">O502<OPTION value="='Graph Data'!N182">P502<OPTION value="='Graph Data'!B206">D503<OPTION value="='Graph Data'!C206">E503<OPTION value="='Graph Data'!D206">F503<OPTION value="='Graph Data'!E206">G503<OPTION value="='Graph Data'!F206">H503<OPTION value="='Graph Data'!G206">I503<OPTION value="='Graph Data'!H206">J503<OPTION value="='Graph Data'!I206">K503<OPTION value="='Graph Data'!J206">L503<OPTION value="='Graph Data'!K206">M503<OPTION value="='Graph Data'!L206">N503<OPTION value="='Graph Data'!M206">O503<OPTION value="='Graph Data'!N206">P503<OPTION value='=IF(OR(P503="n/a",P503="ND"),0,IF(COUNTIF(D503:P503,"<"&B503),MATCH(TRUE,Array3,0)-1,COUNTIF(D503:P503,OR("N/A","ND"))+COUNT(D503:P503)))'>Q503<OPTION value='{=IF(COUNTIF(D503:P503,">"&0.51),MATCH(TRUE,SUBTOTAL(9,OFFSET(D503:P503,,LARGE(IF(D503:P503<>"",COLUMN(D503:P503)-COLUMN(D503)),ROW(INDIRECT("1:"&COLUMNS(D503:P503)))),,1))>0.51,0)-1,COUNT(D503:P503))}'>R503<OPTION value="='Graph Data'!B230">D504<OPTION value="='Graph Data'!C230">E504<OPTION value="='Graph Data'!D230">F504<OPTION value="='Graph Data'!E230">G504<OPTION value="='Graph Data'!F230">H504<OPTION value="='Graph Data'!G230">I504<OPTION value="='Graph Data'!H230">J504<OPTION value="='Graph Data'!I230">K504<OPTION value="='Graph Data'!J230">L504<OPTION value="='Graph Data'!K230">M504<OPTION value="='Graph Data'!L230">N504<OPTION value="='Graph Data'!M230">O504<OPTION value="='Graph Data'!N230">P504<OPTION value='=IF(OR(P504="n/a",P504="ND"),0,IF(COUNTIF(D504:P504,"<"&B504),MATCH(TRUE,Array3,0)-1,COUNTIF(D504:P504,OR("N/A","ND"))+COUNT(D504:P504)))'>Q504<OPTION value='{=IF(COUNTIF(D504:P504,">"&0.51),MATCH(TRUE,SUBTOTAL(9,OFFSET(D504:P504,,LARGE(IF(D504:P504<>"",COLUMN(D504:P504)-COLUMN(D504)),ROW(INDIRECT("1:"&COLUMNS(D504:P504)))),,1))>0.51,0)-1,COUNT(D504:P504))}'>R504<OPTION value="='Graph Data'!B254">D505<OPTION value="='Graph Data'!C254">E505<OPTION value="='Graph Data'!D254">F505<OPTION value="='Graph Data'!E254">G505<OPTION value="='Graph Data'!F254">H505<OPTION value="='Graph Data'!G254">I505<OPTION value="='Graph Data'!H254">J505<OPTION value="='Graph Data'!I254">K505<OPTION value="='Graph Data'!J254">L505<OPTION value="='Graph Data'!K254">M505<OPTION value="='Graph Data'!L254">N505<OPTION value="='Graph Data'!M254">O505<OPTION value="='Graph Data'!N254">P505<OPTION value="='Graph Data'!B278">D506<OPTION value="='Graph Data'!C278">E506<OPTION value="='Graph Data'!D278">F506<OPTION value="='Graph Data'!E278">G506<OPTION value="='Graph Data'!F278">H506<OPTION value="='Graph Data'!G278">I506<OPTION value="='Graph Data'!H278">J506<OPTION value="='Graph Data'!I278">K506<OPTION value="='Graph Data'!J278">L506<OPTION value="='Graph Data'!K278">M506<OPTION value="='Graph Data'!L278">N506<OPTION value="='Graph Data'!M278">O506<OPTION value="='Graph Data'!N278">P506<OPTION value='=IF(OR(P506="n/a",P506="ND"),0,IF(COUNTIF(D506:P506,"<"&B506),MATCH(TRUE,Array3,0)-1,COUNTIF(D506:P506,OR("N/A","ND"))+COUNT(D506:P506)))'>Q506<OPTION value='{=IF(COUNTIF(D506:P506,">"&0.51),MATCH(TRUE,SUBTOTAL(9,OFFSET(D506:P506,,LARGE(IF(D506:P506<>"",COLUMN(D506:P506)-COLUMN(D506)),ROW(INDIRECT("1:"&COLUMNS(D506:P506)))),,1))>0.51,0)-1,COUNT(D506:P506))}'>R506<OPTION value="='Graph Data'!B302">D507<OPTION value="='Graph Data'!C302">E507<OPTION value="='Graph Data'!D302">F507<OPTION value="='Graph Data'!E302">G507<OPTION value="='Graph Data'!F302">H507<OPTION value="='Graph Data'!G302">I507<OPTION value="='Graph Data'!H302">J507<OPTION value="='Graph Data'!I302">K507<OPTION value="='Graph Data'!J302">L507<OPTION value="='Graph Data'!K302">M507<OPTION value="='Graph Data'!L302">N507<OPTION value="='Graph Data'!M302">O507<OPTION value="='Graph Data'!N302">P507<OPTION value='=IF(OR(P507="n/a",P507="ND"),0,IF(COUNTIF(D507:P507,"<"&B507),MATCH(TRUE,Array3,0)-1,COUNTIF(D507:P507,OR("N/A","ND"))+COUNT(D507:P507)))'>Q507<OPTION value='{=IF(COUNTIF(D507:P507,">"&0.51),MATCH(TRUE,SUBTOTAL(9,OFFSET(D507:P507,,LARGE(IF(D507:P507<>"",COLUMN(D507:P507)-COLUMN(D507)),ROW(INDIRECT("1:"&COLUMNS(D507:P507)))),,1))>0.51,0)-1,COUNT(D507:P507))}'>R507<OPTION value="='Graph Data'!B326">D508<OPTION value="='Graph Data'!C326">E508<OPTION value="='Graph Data'!D326">F508<OPTION value="='Graph Data'!E326">G508<OPTION value="='Graph Data'!F326">H508<OPTION value="='Graph Data'!G326">I508<OPTION value="='Graph Data'!H326">J508<OPTION value="='Graph Data'!I326">K508<OPTION value="='Graph Data'!J326">L508<OPTION value="='Graph Data'!K326">M508<OPTION value="='Graph Data'!L326">N508<OPTION value="='Graph Data'!M326">O508<OPTION value="='Graph Data'!N326">P508<OPTION value='=IF(OR(P508="n/a",P508="ND"),0,IF(COUNTIF(D508:P508,"<"&B508),MATCH(TRUE,Array3,0)-1,COUNTIF(D508:P508,OR("N/A","ND"))+COUNT(D508:P508)))'>Q508<OPTION value='{=IF(COUNTIF(D508:P508,">"&0.51),MATCH(TRUE,SUBTOTAL(9,OFFSET(D508:P508,,LARGE(IF(D508:P508<>"",COLUMN(D508:P508)-COLUMN(D508)),ROW(INDIRECT("1:"&COLUMNS(D508:P508)))),,1))>0.51,0)-1,COUNT(D508:P508))}'>R508<OPTION value="='Graph Data'!B350">D509<OPTION value="='Graph Data'!C350">E509<OPTION value="='Graph Data'!D350">F509<OPTION value="='Graph Data'!E350">G509<OPTION value="='Graph Data'!F350">H509<OPTION value="='Graph Data'!G350">I509<OPTION value="='Graph Data'!H350">J509<OPTION value="='Graph Data'!I350">K509<OPTION value="='Graph Data'!J350">L509<OPTION value="='Graph Data'!K350">M509<OPTION value="='Graph Data'!L350">N509<OPTION value="='Graph Data'!M350">O509<OPTION value="='Graph Data'!N350">P509<OPTION value='=IF(OR(P509="n/a",P509="ND"),0,IF(COUNTIF(D509:P509,"<"&B509),MATCH(TRUE,Array3,0)-1,COUNTIF(D509:P509,OR("N/A","ND"))+COUNT(D509:P509)))'>Q509<OPTION value='{=IF(COUNTIF(D509:P509,">"&0.51),MATCH(TRUE,SUBTOTAL(9,OFFSET(D509:P509,,LARGE(IF(D509:P509<>"",COLUMN(D509:P509)-COLUMN(D509)),ROW(INDIRECT("1:"&COLUMNS(D509:P509)))),,1))>0.51,0)-1,COUNT(D509:P509))}'>R509<OPTION value="='Graph Data'!B374">D510<OPTION value="='Graph Data'!C374">E510<OPTION value="='Graph Data'!D374">F510<OPTION value="='Graph Data'!E374">G510<OPTION value="='Graph Data'!F374">H510<OPTION value="='Graph Data'!G374">I510<OPTION value="='Graph Data'!H374">J510<OPTION value="='Graph Data'!I374">K510<OPTION value="='Graph Data'!J374">L510<OPTION value="='Graph Data'!K374">M510<OPTION value="='Graph Data'!L374">N510<OPTION value="='Graph Data'!M374">O510<OPTION value="='Graph Data'!N374">P510<OPTION value='=IF(OR(P510="n/a",P510="ND"),0,IF(COUNTIF(D510:P510,"<"&B510),MATCH(TRUE,Array3,0)-1,COUNTIF(D510:P510,OR("N/A","ND"))+COUNT(D510:P510)))'>Q510<OPTION value='{=IF(COUNTIF(D510:P510,">"&0.51),MATCH(TRUE,SUBTOTAL(9,OFFSET(D510:P510,,LARGE(IF(D510:P510<>"",COLUMN(D510:P510)-COLUMN(D510)),ROW(INDIRECT("1:"&COLUMNS(D510:P510)))),,1))>0.51,0)-1,COUNT(D510:P510))}'>R510<OPTION value="='Graph Data'!B398">D511<OPTION value="='Graph Data'!C398">E511<OPTION value="='Graph Data'!D398">F511<OPTION value="='Graph Data'!E398">G511<OPTION value="='Graph Data'!F398">H511<OPTION value="='Graph Data'!G398">I511<OPTION value="='Graph Data'!H398">J511<OPTION value="='Graph Data'!I398">K511<OPTION value="='Graph Data'!J398">L511<OPTION value="='Graph Data'!K398">M511<OPTION value="='Graph Data'!L398">N511<OPTION value="='Graph Data'!M398">O511<OPTION value="='Graph Data'!N398">P511<OPTION value='=IF(OR(P511="n/a",P511="ND"),0,IF(COUNTIF(D511:P511,"<"&B511),MATCH(TRUE,Array3,0)-1,COUNTIF(D511:P511,OR("N/A","ND"))+COUNT(D511:P511)))'>Q511<OPTION value='{=IF(COUNTIF(D511:P511,">"&0.51),MATCH(TRUE,SUBTOTAL(9,OFFSET(D511:P511,,LARGE(IF(D511:P511<>"",COLUMN(D511:P511)-COLUMN(D511)),ROW(INDIRECT("1:"&COLUMNS(D511:P511)))),,1))>0.51,0)-1,COUNT(D511:P511))}'>R511<OPTION value="='Graph Data'!B422">D512<OPTION value="='Graph Data'!C422">E512<OPTION value="='Graph Data'!D422">F512<OPTION value="='Graph Data'!E422">G512<OPTION value="='Graph Data'!F422">H512<OPTION value="='Graph Data'!G422">I512<OPTION value="='Graph Data'!H422">J512<OPTION value="='Graph Data'!I422">K512<OPTION value="='Graph Data'!J422">L512<OPTION value="='Graph Data'!K422">M512<OPTION value="='Graph Data'!L422">N512<OPTION value="='Graph Data'!M422">O512<OPTION value="='Graph Data'!N422">P512<OPTION value='=IF(OR(P512="n/a",P512="ND"),0,IF(COUNTIF(D512:P512,"<"&B512),MATCH(TRUE,Array3,0)-1,COUNTIF(D512:P512,OR("N/A","ND"))+COUNT(D512:P512)))'>Q512<OPTION value='{=IF(COUNTIF(D512:P512,">"&0.51),MATCH(TRUE,SUBTOTAL(9,OFFSET(D512:P512,,LARGE(IF(D512:P512<>"",COLUMN(D512:P512)-COLUMN(D512)),ROW(INDIRECT("1:"&COLUMNS(D512:P512)))),,1))>0.51,0)-1,COUNT(D512:P512))}'>R512</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value="='Graph Data'!B$25" name=txbFb426622></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%">
</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>D</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>E</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>F</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>G</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>H</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>I</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>J</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>K</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>L</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>M</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>N</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>O</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>P</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>Q</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>R</CENTER></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>495</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">03/09</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">10/09</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">17/09</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">24/09</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">01/10</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">08/10</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">15/10</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">22/10</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">29/10</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">05/11</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">12/11</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">19/11</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">26/11</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">TTCounter</TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">LowCounter</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>496</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">90%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">47%</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">ND</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>497</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">78%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">70%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">63%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">31%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">89%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">89%</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">ND</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">1</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>498</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">ND</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">1</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>499</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">95%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100%</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">ND</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">1</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>500</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">45%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">56%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">40%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">50%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">65%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">81%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">63%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">55%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">55%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">68%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">50%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">79%</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">ND</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">1</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>501</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">n/a</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">n/a</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">n/a</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">n/a</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">n/a</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">n/a</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">n/a</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">n/a</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">n/a</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">n/a</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">n/a</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">ND</FONT></TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">ND</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">N/A</TD><TD style="BORDER-RIGHT: #000000 1.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">N/A</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>502</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">30%</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document
 
Upvote 0
What should the result be if you have the following row of data...

Code: 
100%	65%	100%	100%	ND	100%	100%	N/A	N/A	100%	100%	100%

If the result should be 9, change the formulas for the defined references as follows...

Array1:

=COUNTIF(OFFSET(Sheet1!$D4:$O4,,LARGE(IF((Sheet1!$D4:$O4<>"")*(Sheet1!$D4:$O4<>"ND"),COLUMN(Sheet1!$D4:$O4)-COLUMN(Sheet1!$D4)),ROW(INDIRECT("1:"&COLUMNS(Sheet1!$D4:$O4)))),,1),"N/A")

Array2:

=SUBTOTAL(9,OFFSET(Sheet1!$D4:$O4,,LARGE(IF((Sheet1!$D4:$O4<>"")*(Sheet1!$D4:$O4<>"ND"),COLUMN(Sheet1!$D4:$O4)-COLUMN(Sheet1!$D4)),ROW(INDIRECT("1:"&COLUMNS(Sheet1!$D4:$O4)))),,1))

Make sure that you select P4 before making any changes to the defined references.

Hope this helps!
 
Upvote 0
Dom this is working great for the highlights section, ie a measure above threshold or target. However I cant get it to omit the n/a's when counting measures below 50%?

Any ideas, and if not thanks for your help so far.

dMac
 
Upvote 0
To be clear, can you provide the results for the following examples, assuming a 50% threshhold...

Code: 
90%	95%	90%	85%	80%	90%	95%	90%	95%	85%	90%	50%
90%	95%	90%	85%	80%	90%	95%	90%	95%	40%	N/A	45%
90%	95%	90%	85%	80%	90%	95%	90%	45%	ND	40%	45%
90%	95%	90%	85%	80%	90%	95%	90%	35%	40%	45%	ND
90%	95%	90%	85%	80%	90%	95%	90%	95%	45%	40%	N/A
90%	95%	90%	85%	80%	90%	95%	90%	40%	45%	90%	90%

P.S. I don't know why there's a problem with this thread, but to copy the examples, hit 'Quote' and copy from there. If you still have problems, let me know and I'll PM you the examples.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
Count a number just the first time it appears in each string.
Replies
8
Views
119
StephenCrump
S
S
  • Question
VBA Challenge
Replies
2
Views
215
SnowyBry
S
O
  • Question
Count only one occurrence of all criteria being met
Replies
8
Views
401
KRice
K
D
  • Question
Applying dupicate Column Headers in an Excel Table
Replies
6
Views
384
awoohaw
awoohaw
A
  • Solved
Pivot Table Sum giving Zeros but count works
Replies
5
Views
556
RoryA
RoryA

Forum statistics

Threads
1,214,523
Messages
6,120,042
Members
448,940
Latest member
mdusw

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