Counting rows to generate stats.

montecarlo2012

montecarlo2012

Well-known Member
Joined
Jan 26, 2011
Messages
984
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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
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.
Max. Rows
Max. Columns
Max Columns by letter
Excel 2010
1,048,576​
16,384​
XFD​
Excel 2007
1,048,576​
16,384​
XFD​
Excel 2003
65,536​
256​
IV​
Excel 2002 (XP)
65,536​
256​
IV​
Excel 2000
65,536​
256​
IV​
Excel 97
65,536​
256​
IV​
Excel 95
16,384​
256​
IV​
Excel 5
16,384​
256​
IV​

<TBODY> </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.
56173134"G1" cell
1418192333123456
511192736
27242730
212262728
914152930
4682428
15161934
210141931
310142932
620232730739600
1521232729503215
162223253123131743
1357985311515
22130313200153
2911293513400
113192026900310
514212329743

<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>
</TBODY>
 
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

S
  • Solved
Individual Ranking
2
Replies
11
Views
370
sksanjeev786
S
J
  • Question
Removing blank rows based on cell value
Replies
2
Views
209
Peter_SSs
Peter_SSs
D
  • Solved
List of items within a specific month
Replies
4
Views
150
Fluff
Fluff
F
  • Question
Changing date format based on fiscal years versus calendar years
Replies
2
Views
136
Peter_SSs
Peter_SSs
K
  • Question
conditional formatting question
Replies
2
Views
507
kerm007
K

Forum statistics

Threads
1,221,501
Messages
6,160,175
Members
451,629
Latest member
MNexcelguy19

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