Counting rows to generate stats.

montecarlo2012

montecarlo2012

Well-known Member
Joined
Jan 26, 2011
Messages
986
Office Version
  1. 2010
Platform
  1. Windows
HELLO.
Trying to accomplish some statistics. I need to see thedistance between every number counting the rows NOT CELL BY CELL; the attach isclear.<o:p></o:p>
1 ) H1 is the max inte, mean take the maximum numberin the distance by row report.<o:p></o:p>
2) I1 is the Trend function apply to that linenumber<o:p></o:p>
3) J1 is theaverage<o:p></o:p>
4) K1 close average is the first number minus average<o:p></o:p>
5) L1 close trendis the first number minus the trend<o:p></o:p>
And after this come the distance report . example the number 5 in the bin the first distance is0 and the second is 1 number 5 shows up in the first row mean iqual 0 afterjump one row so reason why the number in N6 is 1, second example is number 1 inA8 so the number in M2 is 7 because one jump seven lines count from the first.
My bin is G2:G37 (numbers from 1 to 36)
My data is A1:E4000
Code: 
[/SIZE]
[TABLE="width: 768"]
[SIZE=3] [/SIZE]<colgroup><col style="width: 48pt;" span="16" width="64">[SIZE=3][/SIZE][SIZE=3] [/SIZE]<tbody>[TR]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]G[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]H[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]I[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]J[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]K[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]L[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]M[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]N[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]O[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]P[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]Q[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]R[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]S[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]T[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]U[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, width: 64, bgcolor: transparent"][SIZE=3]V[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3]max inte[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3]trend[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3]average[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3]close/av[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3]close/tre[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]1[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]14[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]6.727273[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]4.6[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]2.4[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]0.272727[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]7[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]5[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]8[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]0[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]14[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]7[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]0[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]1[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]7[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]2.311111[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]2.777778[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]0.222222[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]0.688889[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]0[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]5[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]0[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]7[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]0[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]4[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]13[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]8.25[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]7.875[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]1.125[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]0.75[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]9[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]13[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]13[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]1[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]10[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]4[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]10[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]4[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]39[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]17.8[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]11.2[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]-5.2[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]-11.8[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]6[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]39[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]1[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]8[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]5[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]5[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]1.666667[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]2.166667[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]-2.16667[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]-1.66667[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]0[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]1[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]4[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]5[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]0[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent, align: right"][SIZE=3]6[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl63, bgcolor: transparent"][SIZE=3] [/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3][/SIZE]</tbody>[/TABLE]

[SIZE=3]
DATA EXAMPLE
Code: 
[/SIZE]
[TABLE="width: 240"]
[SIZE=3] [/SIZE]<colgroup><col style="width: 48pt;" span="5" width="64">[SIZE=3][/SIZE][SIZE=3] [/SIZE]<tbody>[TR]
[SIZE=3]  [/SIZE][TD="class: xl65, width: 64, bgcolor: transparent, align: right"][SIZE=3]5[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, width: 64, bgcolor: transparent, align: right"][SIZE=3]6[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, width: 64, bgcolor: transparent, align: right"][SIZE=3]17[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, width: 64, bgcolor: transparent, align: right"][SIZE=3]31[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, width: 64, bgcolor: transparent, align: right"][SIZE=3]34[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]14[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]18[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]19[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]23[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]33[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]5[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]11[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]19[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]27[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]36[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]7[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]24[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]27[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]30[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]12[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]26[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]27[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]28[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]9[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]14[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]15[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]29[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]30[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]4[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]6[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]8[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]24[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]28[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]1[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]5[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]16[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]19[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]34[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]10[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]14[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]19[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]31[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]10[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]14[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]29[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]32[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]6[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]20[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]23[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]27[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]30[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]15[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]21[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]23[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]27[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]29[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]16[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]22[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]23[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]25[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]31[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]1[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]5[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]7[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]9[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]21[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]30[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]31[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]32[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]9[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]11[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]29[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]35[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]1[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]13[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]19[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]20[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]26[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]5[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]14[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]21[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]23[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]29[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]5[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]9[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]11[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]15[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]36[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]14[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]18[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]21[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]35[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]17[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]22[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]27[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]33[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]9[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]14[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]16[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]23[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]26[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]9[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]11[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]13[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]29[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]34[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]7[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]20[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]29[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]31[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]36[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]11[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]24[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]26[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]27[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]35[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]1[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]10[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]17[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]19[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]22[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]1[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]6[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]10[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]15[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]36[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]3[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]25[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]26[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]33[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]36[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]8[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]11[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]13[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]29[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3] [/SIZE][TR]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]2[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]5[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]21[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]26[/SIZE][/TD]
[SIZE=3]  [/SIZE][TD="class: xl65, bgcolor: transparent, align: right"][SIZE=3]35[/SIZE][/TD]
[SIZE=3] [/SIZE][/TR]
[SIZE=3][/SIZE]</tbody>[/TABLE]

[SIZE=3]
thanks for reading this post.

<o:p> </o:p>
<o:p> </o:p>
 
Sort by date Sort by votes

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Hi MickG. I am still working in this code, I realize my excel is 2010 home edition and have only 256 columns, so, PLEASE would be possible maybe to change the vertical bin for a horizontal bin. thank you.
 
Upvote 0
Maybe in this way I got the real facts, no short limits. thanks MickG.
Code: 
[TABLE="width: 378"]
<tbody>[TR]
[TD="class: xl63, width: 95, bgcolor: #D9D9D9, align: right"][FONT=Calibri]1[/FONT]
[/TD]
[TD="class: xl64, width: 89, bgcolor: #D9D9D9"][FONT=Calibri][SIZE=3][COLOR=#000000]A[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, width: 64, bgcolor: #D9D9D9"][FONT=Calibri][SIZE=3][COLOR=#000000]B[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, width: 64, bgcolor: #D9D9D9"][FONT=Calibri][SIZE=3][COLOR=#000000]C[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, width: 64, bgcolor: #D9D9D9"][FONT=Calibri][SIZE=3][COLOR=#000000]D[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, width: 64, bgcolor: #D9D9D9"][FONT=Calibri][SIZE=3][COLOR=#000000]E[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl65, width: 64, bgcolor: #D9D9D9"][FONT=Calibri][SIZE=3][COLOR=#000000]F[/COLOR][/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9, align: right"][FONT=Calibri]2[/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9, align: right"][FONT=Calibri]3[/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000]bin[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]1[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]2[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]3[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]4[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]5[/COLOR][/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9, align: right"][FONT=Calibri]4[/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000]major absent[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]24[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]36[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]30[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]39[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]33[/COLOR][/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9, align: right"][FONT=Calibri]5[/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000]average[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]5.831967[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]5.834025[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]6.117647[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]5.694915[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]6.86722[/COLOR][/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9, align: right"][FONT=Calibri]6[/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000]close average[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]3.168033[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]-5.83402[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]-0.11765[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]-1.69492[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]-1.86722[/COLOR][/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9, align: right"][FONT=Calibri]7[/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9, align: right"][FONT=Calibri]8[/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9, align: right"][FONT=Calibri]9[/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000]absent[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]9[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]0[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9, align: right"][FONT=Calibri]10[/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]3[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]7[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9, align: right"][FONT=Calibri]11[/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]1[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]7[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9, align: right"][FONT=Calibri]12[/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]4[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]2[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #D9D9D9, align: right"][FONT=Calibri]13[/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]11[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]8[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
If you are using "2010" the column should not be limited to 256:-
See below:-

All the talk about 64-bit versions of Office has raised the issue of maximum rows and columns in Excel.
A few readers seem to believe that 64-bit Excel will have more rows or columns than the 32-bit version. While that might be theoretically possible, it’s not true.
The maximum rows/columns in Excel is limited by the version of the product, not it’s ‘bitness’.
Having larger worksheet sizes just for 64-bit Excel would cause all sorts of document compatibility issues. Microsoft rightly wants their documents accessible to all copies of that application and version – regardless of whether it is 32-bit and 64-bit.
The reader messages made it clear that it’s still commonly believed that Excel is limited to 65,536 rows when Excel 2007 (32-bit) increased that to 1,048,576 rows.

<TBODY>
[TD="width: 128"][/TD]
[TD="width: 135"] Max. Rows
[/TD]
[TD="width: 130"] Max. Columns
[/TD]
[TD="width: 128"] Max Columns by letter
[/TD]

[TD="width: 128"] Excel 2010
[/TD]
[TD="width: 135"]
1,048,576​
[/TD]
[TD="width: 130"]
16,384​
[/TD]
[TD="width: 128"]
XFD​
[/TD]

[TD="width: 128"] Excel 2007
[/TD]
[TD="width: 135"]
1,048,576​
[/TD]
[TD="width: 130"]
16,384​
[/TD]
[TD="width: 128"]
XFD​
[/TD]

[TD="width: 128"] Excel 2003
[/TD]
[TD="width: 135"]
65,536​
[/TD]
[TD="width: 130"]
256​
[/TD]
[TD="width: 128"]
IV​
[/TD]

[TD="width: 128"] Excel 2002 (XP)
[/TD]
[TD="width: 135"]
65,536​
[/TD]
[TD="width: 130"]
256​
[/TD]
[TD="width: 128"]
IV​
[/TD]

[TD="width: 128"] Excel 2000
[/TD]
[TD="width: 135"]
65,536​
[/TD]
[TD="width: 130"]
256​
[/TD]
[TD="width: 128"]
IV​
[/TD]

[TD="width: 128"] Excel 97
[/TD]
[TD="width: 135"]
65,536​
[/TD]
[TD="width: 130"]
256​
[/TD]
[TD="width: 128"]
IV​
[/TD]

[TD="width: 128"] Excel 95
[/TD]
[TD="width: 135"]
16,384​
[/TD]
[TD="width: 130"]
256​
[/TD]
[TD="width: 128"]
IV​
[/TD]

[TD="width: 128"] Excel 5
[/TD]
[TD="width: 135"]
16,384​
[/TD]
[TD="width: 130"]
256​
[/TD]
[TD="width: 128"]
IV​
[/TD]

</TBODY>

Excel 2007/2010 will show the Excel 2003 limits (65,536 x 256) when opening a .xls document. To get larger worksheets, save the document to the Excel 2007 .docx format.
The number of worksheets in a single document/spreadsheet is another constraint. Excel 2007/2010 can theoretically handle 255 worksheets in a single document; however the practical limit is memory. The amount of memory available to Excel depends on both the operating system and version of Excel.
Excel 64-bit can access considerably more RAM and thus can deal with more worksheets at the same time. Excel 2010 and Excel 2007 32-bit versions have an upper memory limit of 2GB though other limitations may kick-in before you reach that. Excel 2010 64-bit can theoretically access 8 TERAbytes of memory, a 4,000 fold increase.
<!-- Ad start -->
 
Upvote 0
Thank you MickG.
I undertstand, for some reason my excel work that way, really sorry, thats why I am talking about IF it is possible to putting the same ideas by columns, instead of rows like you did already, I don't want to bother to much, I really understand the great person you are, trying to help people like me, just because your generosity, really thanks for your time, you alway help me.
 
Upvote 0
Try this
Run in you basic data sheet (as previous) for the basic Results , starting "G2"

Code: 
[COLOR=navy]Sub[/COLOR] MG17Nov51
[COLOR=navy]Dim[/COLOR] Rng     [COLOR=navy]As[/COLOR] Range
[COLOR=navy]Dim[/COLOR] Dn      [COLOR=navy]As[/COLOR] Range
[COLOR=navy]Dim[/COLOR] Rw      [COLOR=navy]As[/COLOR] Range
[COLOR=navy]Dim[/COLOR] n       [COLOR=navy]As[/COLOR] [COLOR=navy]Long[/COLOR]
[COLOR=navy]Dim[/COLOR] Q       [COLOR=navy]As[/COLOR] Variant
[COLOR=navy]Dim[/COLOR] Omax    [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]Dim[/COLOR] oSub    [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]Set[/COLOR] Rng = Range(Range("A1"), Range("A" & Rows.Count).End(xlUp)).Resize(, 5)
    ReDim Ray(1 To Rng.Count, 1 To 2)
        [COLOR=navy]With[/COLOR] CreateObject("scripting.dictionary")
            .CompareMode = vbTextCompare
[COLOR=navy]For[/COLOR] [COLOR=navy]Each[/COLOR] Rw [COLOR=navy]In[/COLOR] Rng.Rows
    n = n + 1
[COLOR=navy]For[/COLOR] [COLOR=navy]Each[/COLOR] Dn [COLOR=navy]In[/COLOR] Rw.Columns
    
    [COLOR=navy]If[/COLOR] Not .Exists(Dn.Value) [COLOR=navy]Then[/COLOR]
        Ray(1, 1) = n - 1: Ray(1, 2) = n - 1
        .Add Dn.Value, Array(Ray, 1)
    [COLOR=navy]Else[/COLOR]
        Q = .Item(Dn.Value)
            Q(1) = Q(1) + 1
            oSub = IIf(Q(1) > 2, 1, 2)
            Q(0)(Q(1), 1) = n
            Q(0)(Q(1), 2) = n - Q(0)(Q(1) - 1, 1) - oSub
            Omax = Application.Max(Omax, Q(1))
        .Item(Dn.Value) = Q
[COLOR=navy]End[/COLOR] If
[COLOR=navy]Next[/COLOR] Dn
[COLOR=navy]Next[/COLOR] Rw
[COLOR=navy]Dim[/COLOR] K [COLOR=navy]As[/COLOR] Variant
[COLOR=navy]Dim[/COLOR] r [COLOR=navy]As[/COLOR] [COLOR=navy]Long[/COLOR]
[COLOR=navy]Dim[/COLOR] C [COLOR=navy]As[/COLOR] [COLOR=navy]Long[/COLOR]
 
 [COLOR=navy]For[/COLOR] [COLOR=navy]Each[/COLOR] K [COLOR=navy]In[/COLOR] .keys
    C = C + 1
    Cells(2, 6 + C) = K
     [COLOR=navy]For[/COLOR] r = 1 To .Item(K)(1)
            Cells(10 + r, 6 + C) = .Item(K)(0)(r, 2)
        [COLOR=navy]Next[/COLOR] r
 [COLOR=navy]Next[/COLOR] K
Range("G2").Resize(Omax + 10, .Count).Sort Key1:=Range("G2"), Order1:=xlAscending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight, _
        DataOption1:=xlSortNormal
'[COLOR=green][B]    Call RwData(Range("M2").Resize(.Count), Omax)[/B][/COLOR]
[COLOR=navy]End[/COLOR] [COLOR=navy]With[/COLOR]
[COLOR=navy]End[/COLOR] [COLOR=navy]Sub[/COLOR]
Regards Mick
 
Upvote 0
Hi, MickG thanks.
I tested the new one, took like four minutes to finish, and the bin on G2 do not start with the number one, and is not in a sequence order, and from the numbers 1 to 36 omit 6 numbers and repeat numbers like 24.27.31.
I putting my data in A1:E6057
Code: 
[TABLE="width: 624"]
 <colgroup><col style="width: 48pt;" span="13" width="64"> <tbody>[TR]
  [TD="class: xl63, width: 64, bgcolor: transparent, align: right"][FONT=Calibri]2[/FONT][/TD]
  [TD="class: xl63, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]9[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]10[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]19[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]21[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]16[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, width: 64, align: right"]27[/TD]
  [TD="class: xl63, width: 64, align: right"]31[/TD]
  [TD="class: xl63, width: 64, align: right"]36[/TD]
  [TD="class: xl63, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]6[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]7[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, width: 64, align: right"]26[/TD]
  [TD="class: xl63, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]17[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri] [/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri] [/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
 [/TR]
</tbody>[/TABLE]
thats the bin
 
Upvote 0
This is a small portion of the basic data and results after running then code.
What do you get with the basic data.
NB:- Row 2 Bins, Row 11 results.
[TABLE="width: 503"]
<COLGROUP><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1649" width=46><COL style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 1422" width=40><COL style="WIDTH: 28pt; mso-width-source: userset; mso-width-alt: 1336" width=38><COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1735" width=49><COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1763" width=50><COL style="WIDTH: 48pt" span=7 width=64><TBODY>[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]5[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]6[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]17[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]31[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]34[/TD]
[TD="class: xl24, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl24, width: 64, bgcolor: transparent"]"G1" cell[/TD]
[TD="class: xl24, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl24, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl24, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl24, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl24, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]14[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]18[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]19[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]23[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]33[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]5[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]6[/TD]
[/TR]
[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]5[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]11[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]19[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]27[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]36[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]2[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]7[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]24[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]27[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]30[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]2[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]12[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]26[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]27[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]28[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]9[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]14[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]15[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]29[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]30[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]4[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]6[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]8[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]24[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]28[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]1[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]5[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]16[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]19[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]34[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]2[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]10[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]14[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]19[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]31[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]3[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]10[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]14[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]29[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]32[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]6[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]20[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]23[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]27[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]30[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]9[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]15[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]21[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]23[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]27[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]29[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]5[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]16[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]22[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]23[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]25[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]31[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]13[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]17[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]1[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]3[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]5[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]7[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]9[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]8[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]5[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]11[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]5[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]15[/TD]
[/TR]
[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]2[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]21[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]30[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]31[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]32[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]5[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]2[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]9[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]11[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]29[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]35[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]1[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]13[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]19[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]20[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]26[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]9[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]10[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl25, width: 46, bgcolor: #ccffff"]5[/TD]
[TD="class: xl26, width: 40, bgcolor: #ccffff"]14[/TD]
[TD="class: xl26, width: 38, bgcolor: #ccffff"]21[/TD]
[TD="class: xl26, width: 49, bgcolor: #ccffff"]23[/TD]
[TD="class: xl26, width: 50, bgcolor: #ccffff"]29[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl24, bgcolor: transparent"][/TD]
[TD="class: xl24, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl24, bgcolor: transparent"] [/TD]
[/TR]
</TBODY>[/TABLE]
 
Upvote 0
Thanks MickG, the problem is my computer. I am deeply grateful for what you have doing for me.
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Locked
  • Question Question
VBA Userform - Change from 1900 Date Format to Long Date
Replies
1
Views
61
Peter_SSs
Peter_SSs
V
  • Question Question
Dynamic arrays, circular arguments and all I want to due is increment a previous number
Replies
3
Views
85
djclements
djclements
S
  • Solved
Individual Ranking
2
Replies
11
Views
455
sksanjeev786
S
G
  • Question Question
Format Pulled Data from Workbook into a Text Box
Replies
3
Views
53
Skyybot
Skyybot
V
  • Solved
Creating a new filtered list from a dynamically created list based on previous numbers
Replies
6
Views
129
DanteAmor
DanteAmor

Forum statistics

Threads
1,223,938
Messages
6,175,528
Members
452,651
Latest member
wordsearch

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