Sum functions multiple x 25 , turn into macro . Hopefully .

[Sunline]

Hello all , I have the following functions which I greatfully received from here .
My problem is that my computer jams up and wont process anymore at about row
50,000 of 171,000 .
These examples are for Fast , range HK2:IK2="Fast" . I also have to do the same for ,
Good , Dead , Soft , Heavy , all the same ranges otherwise . So currently running 25 of these side by side .

They are looking to see if in cell HK2 is Fast , then look in sister cell CC2 if 1 or 1= exists .
Next look at HL2 for Fast and CD2 and see if 1 or 1= exists and so on .
Once all of these occurences are found , if any at all , then total number found otherwise zero 0 .
First answer of these 25 functions starts in cell NB2 .
=SUM((HK2:IK2="Fast")*((CC2:DC2=1)+(CC2:DC2="1=")))
=SUM((HK2:IK2="Fast")*((CC2:DC2=2)+(CC2:DC2="2=")))
=SUM((HK2:IK2="Fast")*((CC2:DC2=3)+(CC2:DC2="3=")))
=SUM((HK2:IK2="Fast")*((CC2:DC2=4)+(CC2:DC2="4=")))
=SUM((HK2:IK2="Fast")*((CC2:DC2>=5)+(CC2:DC2>="5=")*(CC2:DC2="6=")*(CC2:DC2="7=")*(CC2:DC2="8=")*(CC2:DC2="9=")*(CC2:DC2="10=")*(CC2:DC2="11=")*(CC2:DC2="12=")*(CC2:DC2="13=")*(CC2:DC2="14=")*(CC2:DC2="15=")*(CC2:DC2="16=")*(CC2:DC2="17=")*(CC2:DC2="B")*(CC2:DC2="D=")*(CC2:DC2="F=")*(CC2:DC2="LR=")*(CC2:DC2="P=")*(CC2:DC2="RO=")*(CC2:DC2="U=")))
Any help or ideas would be great if possible .
Thanks .

 

[anandvarma]

fire a pivot table

 

[pedie]

Anytime you want to recalculate why dont you make the code do it and change it back to values....i think that will make the workbook calculate faster and less heavy

 

[jasonb75]

I would be more worried about correcting the last formula first, that is the one that will be slowing you down, and the result will always be 0.

 

[Sunline]

Thanks for the replies .
1-anandvarma , i have tried and failed to learn what is a basic on here .
2-pedie , yes i think this is best option , only this week i now have macro to change to values .
3-jasonb75 , i will try too improve this last heavy function , it does work correctly and is returning correct answers as i have done random checks .
Thanks too all for you feedback .

 

[jasonb75]

It would appear that way, but I think you will find that

{=SUM((HK2:IK2="Fast")*(CC2:DC2>=5))}

Will give the same results on those random checks.

Edit:- I didn't see the + between the 2nd and 3rd arrays when I said it would always result as 0, but still suggest you test your results with the short formula above.

 

[Sunline]

Jason your a life saver , why did i attempt too question this , i am wrong .

You are absolutely right , i will now take out the > . just made my problem worse but at least the stats remain accurate .
Thanks for that jasonb75 .

 

[jasonb75]

When you use > or < with ranges that have both text and numbers you have to be very specific with criteria.

A text entry is always greater than any numeric value, even numbers that are entered as text. For example, if you had 2 formula results, ="1" and =99999999, being in text format ="1" would be evaluated as the higher value.

How is your data source updated, is it by formula, imported, or edited manually?

Is it just one sheet that is updated (changes made, or new rows added), or do you periodically get new sheets that you would need to re-apply the formula to?

I think your ideal solution is without doubt to use a code based solution, now we just need to work out the best way to do it.

 

[markmzz]

Hello Sunline,

I think that Anandvarma is correct.

You have to think about to use PivotTable.

Look at this:

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH><TH>D</TH><TH>E</TH><TH>F</TH><TH>G</TH><TH>H</TH><TH>I</TH><TH>J</TH><TH>K</TH><TH>L</TH><TH>M</TH><TH>N</TH><TH>O</TH><TH>P</TH><TH>Q</TH><TH>R</TH><TH>S</TH><TH>T</TH><TH>U</TH><TH>V</TH><TH>W</TH><TH>X</TH><TH>Y</TH><TH>Z</TH><TH>AA</TH><TH>AB</TH><TH>AC</TH><TH>AD</TH><TH>AE</TH><TH>AF</TH><TH>AG</TH><TH>AH</TH><TH>AI</TH><TH>AJ</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD>Contar de Col02</TD><TD>Groups</TD><TD>Col02</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="TEXT-ALIGN: right"></TD><TD>Group1</TD><TD style="TEXT-ALIGN: right"></TD><TD>Group2</TD><TD style="TEXT-ALIGN: right"></TD><TD>Group3</TD><TD style="TEXT-ALIGN: right"></TD><TD>Group4</TD><TD style="TEXT-ALIGN: right"></TD><TD>Group5</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD>Total geral</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">5</TD><TD>Col01</TD><TD style="TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: center">1=</TD><TD style="TEXT-ALIGN: center">2</TD><TD style="TEXT-ALIGN: center">2=</TD><TD style="TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: center">3=</TD><TD style="TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: center">4=</TD><TD style="TEXT-ALIGN: right">5</TD><TD style="TEXT-ALIGN: right">6</TD><TD style="TEXT-ALIGN: right">7</TD><TD style="TEXT-ALIGN: right">8</TD><TD style="TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">10</TD><TD>10=</TD><TD>11=</TD><TD>12=</TD><TD>13=</TD><TD>14=</TD><TD>15=</TD><TD>16=</TD><TD>17=</TD><TD>5=</TD><TD>6=</TD><TD>7=</TD><TD>8=</TD><TD>9=</TD><TD>B=</TD><TD>D=</TD><TD>F=</TD><TD>LR=</TD><TD>P=</TD><TD>RO=</TD><TD>U=</TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">6</TD><TD>Dead</TD><TD style="TEXT-ALIGN: right">28 </TD><TD style="TEXT-ALIGN: right">8 </TD><TD style="TEXT-ALIGN: right">31 </TD><TD style="TEXT-ALIGN: right">12 </TD><TD style="TEXT-ALIGN: right">28 </TD><TD style="TEXT-ALIGN: right">10 </TD><TD style="TEXT-ALIGN: right">17 </TD><TD style="TEXT-ALIGN: right">11 </TD><TD style="TEXT-ALIGN: right">24 </TD><TD style="TEXT-ALIGN: right">24 </TD><TD style="TEXT-ALIGN: right">21 </TD><TD style="TEXT-ALIGN: right">24 </TD><TD style="TEXT-ALIGN: right">21 </TD><TD style="TEXT-ALIGN: right">19 </TD><TD style="TEXT-ALIGN: right">8 </TD><TD style="TEXT-ALIGN: right">10 </TD><TD style="TEXT-ALIGN: right">12 </TD><TD style="TEXT-ALIGN: right">13 </TD><TD style="TEXT-ALIGN: right">12 </TD><TD style="TEXT-ALIGN: right">16 </TD><TD style="TEXT-ALIGN: right">15 </TD><TD style="TEXT-ALIGN: right">18 </TD><TD style="TEXT-ALIGN: right">13 </TD><TD style="TEXT-ALIGN: right">13 </TD><TD style="TEXT-ALIGN: right">12 </TD><TD style="TEXT-ALIGN: right">14 </TD><TD style="TEXT-ALIGN: right">12 </TD><TD style="TEXT-ALIGN: right">237 </TD><TD style="TEXT-ALIGN: right">203 </TD><TD style="TEXT-ALIGN: right">225 </TD><TD style="TEXT-ALIGN: right">228 </TD><TD style="TEXT-ALIGN: right">230 </TD><TD style="TEXT-ALIGN: right">228 </TD><TD style="TEXT-ALIGN: right">215 </TD><TD style="TEXT-ALIGN: right">2,012 </TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">7</TD><TD>Fast</TD><TD style="TEXT-ALIGN: right">22 </TD><TD style="TEXT-ALIGN: right">12 </TD><TD style="TEXT-ALIGN: right">24 </TD><TD style="TEXT-ALIGN: right">12 </TD><TD style="TEXT-ALIGN: right">26 </TD><TD style="TEXT-ALIGN: right">9 </TD><TD style="TEXT-ALIGN: right">30 </TD><TD style="TEXT-ALIGN: right">13 </TD><TD style="TEXT-ALIGN: right">16 </TD><TD style="TEXT-ALIGN: right">21 </TD><TD style="TEXT-ALIGN: right">18 </TD><TD style="TEXT-ALIGN: right">27 </TD><TD style="TEXT-ALIGN: right">18 </TD><TD style="TEXT-ALIGN: right">20 </TD><TD style="TEXT-ALIGN: right">17 </TD><TD style="TEXT-ALIGN: right">12 </TD><TD style="TEXT-ALIGN: right">16 </TD><TD style="TEXT-ALIGN: right">16 </TD><TD style="TEXT-ALIGN: right">16 </TD><TD style="TEXT-ALIGN: right">12 </TD><TD style="TEXT-ALIGN: right">13 </TD><TD style="TEXT-ALIGN: right">15 </TD><TD style="TEXT-ALIGN: right">17 </TD><TD style="TEXT-ALIGN: right">8 </TD><TD style="TEXT-ALIGN: right">11 </TD><TD style="TEXT-ALIGN: right">15 </TD><TD style="TEXT-ALIGN: right">10 </TD><TD style="TEXT-ALIGN: right">227 </TD><TD style="TEXT-ALIGN: right">207 </TD><TD style="TEXT-ALIGN: right">188 </TD><TD style="TEXT-ALIGN: right">184 </TD><TD style="TEXT-ALIGN: right">233 </TD><TD style="TEXT-ALIGN: right">226 </TD><TD style="TEXT-ALIGN: right">206 </TD><TD style="TEXT-ALIGN: right">1,917 </TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">8</TD><TD>Good</TD><TD style="TEXT-ALIGN: right">22 </TD><TD style="TEXT-ALIGN: right">18 </TD><TD style="TEXT-ALIGN: right">21 </TD><TD style="TEXT-ALIGN: right">17 </TD><TD style="TEXT-ALIGN: right">18 </TD><TD style="TEXT-ALIGN: right">14 </TD><TD style="TEXT-ALIGN: right">33 </TD><TD style="TEXT-ALIGN: right">17 </TD><TD style="TEXT-ALIGN: right">24 </TD><TD style="TEXT-ALIGN: right">18 </TD><TD style="TEXT-ALIGN: right">32 </TD><TD style="TEXT-ALIGN: right">20 </TD><TD style="TEXT-ALIGN: right">13 </TD><TD style="TEXT-ALIGN: right">22 </TD><TD style="TEXT-ALIGN: right">7 </TD><TD style="TEXT-ALIGN: right">18 </TD><TD style="TEXT-ALIGN: right">16 </TD><TD style="TEXT-ALIGN: right">11 </TD><TD style="TEXT-ALIGN: right">15 </TD><TD style="TEXT-ALIGN: right">12 </TD><TD style="TEXT-ALIGN: right">11 </TD><TD style="TEXT-ALIGN: right">10 </TD><TD style="TEXT-ALIGN: right">13 </TD><TD style="TEXT-ALIGN: right">14 </TD><TD style="TEXT-ALIGN: right">16 </TD><TD style="TEXT-ALIGN: right">18 </TD><TD style="TEXT-ALIGN: right">13 </TD><TD style="TEXT-ALIGN: right">228 </TD><TD style="TEXT-ALIGN: right">225 </TD><TD style="TEXT-ALIGN: right">232 </TD><TD style="TEXT-ALIGN: right">207 </TD><TD style="TEXT-ALIGN: right">210 </TD><TD style="TEXT-ALIGN: right">220 </TD><TD style="TEXT-ALIGN: right">234 </TD><TD style="TEXT-ALIGN: right">2,019 </TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">9</TD><TD>Heavy</TD><TD style="TEXT-ALIGN: right">21 </TD><TD style="TEXT-ALIGN: right">14 </TD><TD style="TEXT-ALIGN: right">27 </TD><TD style="TEXT-ALIGN: right">12 </TD><TD style="TEXT-ALIGN: right">34 </TD><TD style="TEXT-ALIGN: right">10 </TD><TD style="TEXT-ALIGN: right">28 </TD><TD style="TEXT-ALIGN: right">18 </TD><TD style="TEXT-ALIGN: right">24 </TD><TD style="TEXT-ALIGN: right">25 </TD><TD style="TEXT-ALIGN: right">26 </TD><TD style="TEXT-ALIGN: right">28 </TD><TD style="TEXT-ALIGN: right">22 </TD><TD style="TEXT-ALIGN: right">21 </TD><TD style="TEXT-ALIGN: right">12 </TD><TD style="TEXT-ALIGN: right">10 </TD><TD style="TEXT-ALIGN: right">18 </TD><TD style="TEXT-ALIGN: right">13 </TD><TD style="TEXT-ALIGN: right">16 </TD><TD style="TEXT-ALIGN: right">20 </TD><TD style="TEXT-ALIGN: right">9 </TD><TD style="TEXT-ALIGN: right">15 </TD><TD style="TEXT-ALIGN: right">26 </TD><TD style="TEXT-ALIGN: right">11 </TD><TD style="TEXT-ALIGN: right">15 </TD><TD style="TEXT-ALIGN: right">15 </TD><TD style="TEXT-ALIGN: right">17 </TD><TD style="TEXT-ALIGN: right">235 </TD><TD style="TEXT-ALIGN: right">209 </TD><TD style="TEXT-ALIGN: right">200 </TD><TD style="TEXT-ALIGN: right">231 </TD><TD style="TEXT-ALIGN: right">215 </TD><TD style="TEXT-ALIGN: right">200 </TD><TD style="TEXT-ALIGN: right">228 </TD><TD style="TEXT-ALIGN: right">2,025 </TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">10</TD><TD>Soft</TD><TD style="TEXT-ALIGN: right">20 </TD><TD style="TEXT-ALIGN: right">7 </TD><TD style="TEXT-ALIGN: right">23 </TD><TD style="TEXT-ALIGN: right">14 </TD><TD style="TEXT-ALIGN: right">23 </TD><TD style="TEXT-ALIGN: right">17 </TD><TD style="TEXT-ALIGN: right">24 </TD><TD style="TEXT-ALIGN: right">19 </TD><TD style="TEXT-ALIGN: right">24 </TD><TD style="TEXT-ALIGN: right">36 </TD><TD style="TEXT-ALIGN: right">32 </TD><TD style="TEXT-ALIGN: right">25 </TD><TD style="TEXT-ALIGN: right">20 </TD><TD style="TEXT-ALIGN: right">22 </TD><TD style="TEXT-ALIGN: right">15 </TD><TD style="TEXT-ALIGN: right">10 </TD><TD style="TEXT-ALIGN: right">14 </TD><TD style="TEXT-ALIGN: right">12 </TD><TD style="TEXT-ALIGN: right">9 </TD><TD style="TEXT-ALIGN: right">14 </TD><TD style="TEXT-ALIGN: right">12 </TD><TD style="TEXT-ALIGN: right">16 </TD><TD style="TEXT-ALIGN: right">12 </TD><TD style="TEXT-ALIGN: right">11 </TD><TD style="TEXT-ALIGN: right">13 </TD><TD style="TEXT-ALIGN: right">9 </TD><TD style="TEXT-ALIGN: right">20 </TD><TD style="TEXT-ALIGN: right">226 </TD><TD style="TEXT-ALIGN: right">211 </TD><TD style="TEXT-ALIGN: right">234 </TD><TD style="TEXT-ALIGN: right">214 </TD><TD style="TEXT-ALIGN: right">235 </TD><TD style="TEXT-ALIGN: right">210 </TD><TD style="TEXT-ALIGN: right">224 </TD><TD style="TEXT-ALIGN: right">2,027 </TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">11</TD><TD>Total geral</TD><TD style="TEXT-ALIGN: right">113 </TD><TD style="TEXT-ALIGN: right">59 </TD><TD style="TEXT-ALIGN: right">126 </TD><TD style="TEXT-ALIGN: right">67 </TD><TD style="TEXT-ALIGN: right">129 </TD><TD style="TEXT-ALIGN: right">60 </TD><TD style="TEXT-ALIGN: right">132 </TD><TD style="TEXT-ALIGN: right">78 </TD><TD style="TEXT-ALIGN: right">112 </TD><TD style="TEXT-ALIGN: right">124 </TD><TD style="TEXT-ALIGN: right">129 </TD><TD style="TEXT-ALIGN: right">124 </TD><TD style="TEXT-ALIGN: right">94 </TD><TD style="TEXT-ALIGN: right">104 </TD><TD style="TEXT-ALIGN: right">59 </TD><TD style="TEXT-ALIGN: right">60 </TD><TD style="TEXT-ALIGN: right">76 </TD><TD style="TEXT-ALIGN: right">65 </TD><TD style="TEXT-ALIGN: right">68 </TD><TD style="TEXT-ALIGN: right">74 </TD><TD style="TEXT-ALIGN: right">60 </TD><TD style="TEXT-ALIGN: right">74 </TD><TD style="TEXT-ALIGN: right">81 </TD><TD style="TEXT-ALIGN: right">57 </TD><TD style="TEXT-ALIGN: right">67 </TD><TD style="TEXT-ALIGN: right">71 </TD><TD style="TEXT-ALIGN: right">72 </TD><TD style="TEXT-ALIGN: right">1,153 </TD><TD style="TEXT-ALIGN: right">1,055 </TD><TD style="TEXT-ALIGN: right">1,079 </TD><TD style="TEXT-ALIGN: right">1,064 </TD><TD style="TEXT-ALIGN: right">1,123 </TD><TD style="TEXT-ALIGN: right">1,084 </TD><TD style="TEXT-ALIGN: right">1,107 </TD><TD style="TEXT-ALIGN: right">10,000 </TD></TR></TBODY></TABLE>PT


Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="FONT-WEIGHT: bold">Col01</TD><TD style="FONT-WEIGHT: bold">Col02</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="BACKGROUND-COLOR: #ffff00">Dead</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">U=</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="BACKGROUND-COLOR: #ffff00">Heavy</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">7=</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="BACKGROUND-COLOR: #ffff00">Soft</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">P=</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">5</TD><TD style="BACKGROUND-COLOR: #ffff00">Fast</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">RO=</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">6</TD><TD style="BACKGROUND-COLOR: #ffff00">Dead</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">11=</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">7</TD><TD style="BACKGROUND-COLOR: #ffff00">Dead</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">F=</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">8</TD><TD style="BACKGROUND-COLOR: #ffff00">Fast</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">U=</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">9</TD><TD style="BACKGROUND-COLOR: #ffff00">Fast</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">D=</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">10</TD><TD style="BACKGROUND-COLOR: #ffff00">Soft</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">RO=</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">11</TD><TD style="BACKGROUND-COLOR: #ffff00">Fast</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">RO=</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">12</TD><TD style="BACKGROUND-COLOR: #ffff00">Soft</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">16=</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">13</TD><TD style="BACKGROUND-COLOR: #ffff00">Heavy</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">B=</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">14</TD><TD style="BACKGROUND-COLOR: #ffff00">Dead</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">U=</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">15</TD><TD style="BACKGROUND-COLOR: #ffff00">Good</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">3=</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">16</TD><TD style="BACKGROUND-COLOR: #ffff00">Heavy</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">7</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">17</TD><TD style="BACKGROUND-COLOR: #ffff00">Dead</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">B=</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">18</TD><TD style="BACKGROUND-COLOR: #ffff00">Good</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">RO=</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">19</TD><TD style="BACKGROUND-COLOR: #ffff00">Fast</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">B=</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">20</TD><TD style="BACKGROUND-COLOR: #ffff00">Dead</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00">7</TD></TR></TBODY></TABLE>DataS


Markmzz

 

[Sunline]

jasonb75 , all my work is done manually from the web , then apply many functions and macros to get individual stats from alot of w/books and Access as well . Spent alot having macros written to suit , hence why im here trying to learn .

markmzz , yes i will have to learn this , thanks too you both .