Frequency report

montecarlo2012

montecarlo2012

Well-known Member
Joined
Jan 26, 2011
Messages
984
Office Version
  1. 2010
Platform
  1. Windows
Hello everyone.
I am trying to generate a FREQUENCY REPORT but I need the results show up in different way than the regular frequency function, I was trying to do it using =IFERROR(INDEX ....etc. but as you know I think is longer than a vba code, and beside do not work in my case, so the images show exactly what I need.
Code: 
[TABLE="width: 528"]
<tbody>[TR]
[TD="class: xl63, width: 21, bgcolor: #FFC000"][FONT=Calibri]B[/FONT]
[/TD]
[TD="class: xl63, width: 21, bgcolor: #FFC000"][FONT=Calibri][SIZE=3][COLOR=#000000]C[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl63, width: 21, bgcolor: #FFC000"][FONT=Calibri][SIZE=3][COLOR=#000000]D[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl63, width: 21, bgcolor: #FFC000"][FONT=Calibri][SIZE=3][COLOR=#000000]E[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl63, width: 21, bgcolor: #FFC000"][FONT=Calibri][SIZE=3][COLOR=#000000]F[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl63, width: 21, bgcolor: #FFC000"][FONT=Calibri][SIZE=3][COLOR=#000000]G[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl63, width: 64, bgcolor: #FFC000"][FONT=Calibri][SIZE=3][COLOR=#000000]H[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl63, width: 64, bgcolor: #FFC000"][FONT=Calibri][SIZE=3][COLOR=#000000]I[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl63, width: 64, bgcolor: #FFC000"][FONT=Calibri][SIZE=3][COLOR=#000000]J[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl63, width: 64, bgcolor: #FFC000"][FONT=Calibri][SIZE=3][COLOR=#000000]K[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl63, width: 64, bgcolor: #FFC000"][FONT=Calibri][SIZE=3][COLOR=#000000]L[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl63, width: 64, bgcolor: #FFC000"][FONT=Calibri][SIZE=3][COLOR=#000000]M[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl63, width: 64, bgcolor: #FFC000"][FONT=Calibri][SIZE=3][COLOR=#000000]N[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl63, width: 64, bgcolor: #FFC000"][FONT=Calibri][SIZE=3][COLOR=#000000]O[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl63, width: 64, bgcolor: #FFC000"][FONT=Calibri][SIZE=3][COLOR=#000000]P[/COLOR][/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]11[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]19[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]29[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]31[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]37[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]50[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: yellow"][FONT=Calibri][SIZE=3][COLOR=#000000]0 times[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: yellow"][FONT=Calibri][SIZE=3][COLOR=#000000]1 time[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: yellow"][FONT=Calibri][SIZE=3][COLOR=#000000]2 times[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: yellow"][FONT=Calibri][SIZE=3][COLOR=#000000]3 times[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: yellow"][FONT=Calibri][SIZE=3][COLOR=#000000]4 times[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: yellow"][FONT=Calibri][SIZE=3][COLOR=#000000]5 times[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: yellow"][SIZE=3][COLOR=#000000][FONT=Calibri]6 times [/FONT][/COLOR][/SIZE]
[/TD]
[TD="class: xl65, bgcolor: yellow"][FONT=Calibri][SIZE=3][COLOR=#000000]7 times[/COLOR][/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]5[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]12[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]19[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]30[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]41[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]48[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]9[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]4[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]2[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]1[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]5[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]19[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]13[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]14[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]25[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]26[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]37[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]39[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]17[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]6[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]3[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]7[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]21[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]10[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]15[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]21[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]28[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]35[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]41[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]20[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]8[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]10[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]12[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]27[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]1[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]3[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]16[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]19[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]25[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]38[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]34[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]15[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]11[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]13[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]41[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]13[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]19[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]30[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]43[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]46[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]51[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]40[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]16[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]24[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]14[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]5[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]7[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]12[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]22[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]31[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]53[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]18[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]25[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]23[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]5[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]12[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]21[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]24[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]51[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]53[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]22[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]26[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]28[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]2[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]6[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]7[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]11[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]21[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]41[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]32[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]46[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]29[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]14[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]21[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]27[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]31[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]45[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]52[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]33[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]48[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]30[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]23[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]28[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]29[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]36[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]37[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]46[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]35[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]51[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]31[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]2[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]8[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]23[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]27[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]43[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]53[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]38[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]36[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]1[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]28[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]36[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]39[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]44[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]47[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]42[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]37[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]1[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]18[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]23[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]27[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]33[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]36[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]44[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]39[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]14[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]29[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]30[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]41[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]43[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]49[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]49[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]43[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]4[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]26[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]39[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]42[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]45[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]47[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]50[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]45[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]3[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]7[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]10[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]19[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]24[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]27[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]52[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]47[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri]5[/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]13[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]32[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]45[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]47[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]48[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]53[/COLOR][/SIZE][/FONT]
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

this is base on a range of 18 rows but I would like to enter the range I need in different cases, I mean I have to do this many times in different ways.
Any help welcome.
 
Sort by date Sort by votes

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Thank you MickG.
Good way to putting - Before and After-.
BEFORE: your code go from B1:G18 and make the report of how many times the numbers from one to fiftythree are in the array.
Code: 
[TABLE="width: 336"]
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: #C5D9F1"][/TD]
[TD="class: xl65, width: 64, bgcolor: #C5D9F1"][FONT=Calibri][SIZE=3]B[/SIZE][/FONT]
[/TD]
[TD="class: xl65, width: 64, bgcolor: #C5D9F1"][FONT=Calibri][SIZE=3]C[/SIZE][/FONT]
[/TD]
[TD="class: xl65, width: 64, bgcolor: #C5D9F1"][FONT=Calibri][SIZE=3]D[/SIZE][/FONT]
[/TD]
[TD="class: xl65, width: 64, bgcolor: #C5D9F1"][FONT=Calibri][SIZE=3]E[/SIZE][/FONT]
[/TD]
[TD="class: xl65, width: 64, bgcolor: #C5D9F1"][FONT=Calibri][SIZE=3]F[/SIZE][/FONT]
[/TD]
[TD="class: xl65, width: 64, bgcolor: #C5D9F1"][FONT=Calibri][SIZE=3]G[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]1][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]11[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]19[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]29[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]31[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]37[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]50[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]2][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]5[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]12[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]19[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]30[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]41[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]48[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]3][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]13[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]14[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]25[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]26[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]37[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]39[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]4][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]10[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]15[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]21[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]28[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]35[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]41[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]5][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]1[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]3[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]16[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]19[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]25[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]38[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]6][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]13[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]19[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]30[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]43[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]46[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]51[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]7][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]5[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]7[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]12[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]22[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]31[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]53[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]8][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]5[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]12[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]21[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]24[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]51[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]53[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]9][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]2[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]6[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]7[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]11[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]21[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]41[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]10][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]14[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]21[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]27[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]31[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]45[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]52[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]11][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]23[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]28[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]29[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]36[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]37[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]46[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]12][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]2[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]8[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]23[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]27[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]43[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]53[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]13][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]1[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]28[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]36[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]39[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]44[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]47[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]14][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]1[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]18[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]23[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]27[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]33[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]36[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]15][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]14[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]29[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]30[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]41[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]43[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]49[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]16][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]4[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]26[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]39[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]42[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]45[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]47[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]17][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]3[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]7[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]10[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]19[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]24[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]27[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]18][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]5[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]13[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]32[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]45[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]47[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]48[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][FONT=Calibri]19][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]2[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]6[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]7[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]11[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]21[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]41[/SIZE][/FONT]
[/TD]
[/TR]
</tbody>[/TABLE]
So, the report I am looking is start in B2:G19 and highlight B1:G1 like this attach.
Code: 
[TABLE="width: 288"]
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: transparent, align: right"][FONT=Calibri]0[/FONT]
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]1[/SIZE][/FONT]
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]2[/SIZE][/FONT]
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]3[/SIZE][/FONT]
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]4[/SIZE][/FONT]
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]5[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri]1[/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]3[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]6[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]12[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]7[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]21[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri]2[/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]8[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"][FONT=Calibri][SIZE=3]11[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]28[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"][FONT=Calibri][SIZE=3]19[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]41[/SIZE][/FONT]
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri]4[/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]10[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]23[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]30[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]27[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri]5[/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]13[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]24[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]36[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri]9[/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]14[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]25[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]39[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri]17[/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]15[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]26[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]43[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri]20[/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]16[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"][FONT=Calibri][SIZE=3]29[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]45[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri]34[/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]18[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"][FONT=Calibri][SIZE=3]31[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]47[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri]40[/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]22[/SIZE][/FONT]
[/TD]
[TD="class: xl66, bgcolor: yellow, align: right"][FONT=Calibri][SIZE=3]37[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]53[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"][FONT=Calibri]50[/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]32[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]46[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]33[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]48[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]35[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]51[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]38[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]42[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]44[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]49[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3]52[/SIZE][/FONT]
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
Here you can see is the same RANGE (18 rows) but start in different point.
 
Last edited:
Upvote 0
This is basically the same code , but with the Results Highlighted as specified
Results on sheet (2)
Code: 
[COLOR="Navy"]Sub[/COLOR] MG17Oct33
[COLOR="Navy"]Dim[/COLOR] oMax        [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Rng         [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Dn          [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] nMax        [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Ac          [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Rw          [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] c           [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long[/COLOR]
[COLOR="Navy"]Dim[/COLOR] n           [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long[/COLOR]
[COLOR="Navy"]Dim[/COLOR] nRng        [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Cl          [COLOR="Navy"]As[/COLOR] Range
ReDim nRay(1 To 54, 1 To 54)
[COLOR="Navy"]Set[/COLOR] Rng = Range("B1:G19")
    oMax = application.Max(Rng)
        ReDim Ray(1 To oMax, 1 To 2)
[COLOR="Navy"]For[/COLOR] n = 1 To oMax
    [COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Dn [COLOR="Navy"]In[/COLOR] Rng
        Ray(n, 1) = n
            [COLOR="Navy"]If[/COLOR] Dn = n [COLOR="Navy"]Then[/COLOR] Ray(n, 2) = Ray(n, 2) + 1
    [COLOR="Navy"]Next[/COLOR] Dn
[COLOR="Navy"]Next[/COLOR] n
[COLOR="Navy"]For[/COLOR] Ac = 0 To 53
    c = 1
    nRay(1, Ac + 1) = Ac
        [COLOR="Navy"]For[/COLOR] Rw = 1 To 53
            nMax = application.Max(Ray(Rw, 2), nMax)
            Ray(Rw, 2) = IIf(Ray(Rw, 2) = "", 0, Ray(Rw, 2))
            [COLOR="Navy"]If[/COLOR] Ray(Rw, 2) = Ac [COLOR="Navy"]Then[/COLOR]
                c = c + 1
                nRay(c, Ac + 1) = Ray(Rw, 1)
            [COLOR="Navy"]End[/COLOR] If
        [COLOR="Navy"]Next[/COLOR] Rw
 [COLOR="Navy"]Next[/COLOR] Ac
[COLOR="Navy"]With[/COLOR] Sheets("Sheet2")
    [COLOR="Navy"]Set[/COLOR] nRng = .Range("A1").Resize(53, nMax + 1)
        nRng = nRay
          [COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Dn [COLOR="Navy"]In[/COLOR] Range("B1:G1")
                [COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Cl [COLOR="Navy"]In[/COLOR] nRng
                    [COLOR="Navy"]If[/COLOR] Cl = Dn [COLOR="Navy"]Then[/COLOR] Cl.Interior.ColorIndex = 6
                [COLOR="Navy"]Next[/COLOR] Cl
            [COLOR="Navy"]Next[/COLOR] Dn
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]With[/COLOR]
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]
Regards Mick
 
Upvote 0
Hi MickG I am trying to make it work your code in the following data but I couldn't.
Code: 
[TABLE="width: 336"]
 <colgroup><col style="width: 48pt;" span="7" width="64"> <tbody>[TR]
  [TD="class: xl63, width: 64, bgcolor: black"][FONT=Calibri] [/FONT][/TD]
  [TD="class: xl64, width: 64, bgcolor: #A6A6A6"][FONT=Calibri][SIZE=3][COLOR=#000000]B[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl64, width: 64, bgcolor: #A6A6A6"][FONT=Calibri][SIZE=3][COLOR=#000000]C[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl64, width: 64, bgcolor: #A6A6A6"][FONT=Calibri][SIZE=3][COLOR=#000000]D[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl64, width: 64, bgcolor: #A6A6A6"][FONT=Calibri][SIZE=3][COLOR=#000000]E[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl64, width: 64, bgcolor: #A6A6A6"][FONT=Calibri][SIZE=3][COLOR=#000000]F[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl65, width: 64, bgcolor: #A6A6A6"][FONT=Calibri][SIZE=3][COLOR=#000000]G[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]2[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]146[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]16[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]80[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]21[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]60[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]36[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]3[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]55[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]25[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]173[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]41[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]34[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]17[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]4[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]37[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]26[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]32[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]273[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]16[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]23[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]5[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]58[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]59[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]46[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]12[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]30[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]78[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]6[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]98[/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]29[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]39[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]70[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]35[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]7[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]73[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]80[/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]40[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]11[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]36[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]8[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]19[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]68[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]62[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]72[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]150[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]48[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]9[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]31[/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]10[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]148[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]53[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]60[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]10[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]86[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]26[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]68[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]40[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]94[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]17[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]11[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]61[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]25[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]21[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]103[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]53[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]119[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]12[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]8[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]195[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]29[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]33[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]70[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]96[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]13[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]55[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]19[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]33[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]40[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]34[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]53[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]14[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]92[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]20[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]45[/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]46[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]54[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]15[/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]33[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]34[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]75[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]131[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]60[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]16[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]61[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]135[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]39[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]92[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]149[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]47[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]17[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]97[/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, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]70[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]11[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]65[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]42[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]18[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]52[/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]63[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]41[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]17[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]138[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]19[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]31[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]33[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]22[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]27[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]18[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]102[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]20[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]19[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]43[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]17[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]80[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]53[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]64[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]21[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]81[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]117[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]27[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]44[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]161[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]36[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]22[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]49[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]73[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]127[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]8[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]315[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]94[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]23[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]74[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]70[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]57[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]41[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]36[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]17[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]24[/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, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]15[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]8[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]79[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]22[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]12[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]25[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]61[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]82[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]11[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]59[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]108[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]30[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]26[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]19[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]110[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]50[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]116[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]8[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]40[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]27[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]31[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]111[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]16[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]63[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]41[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]72[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]28[/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]14[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]26[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]15[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]52[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]70[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]29[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]43[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]56[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]15[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]16[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]23[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]66[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]30[/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, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]94[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]12[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]21[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]72[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]24[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]31[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]61[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]99[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]64[/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]47[/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: #A6A6A6, align: right"][FONT=Calibri]32[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]50[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]94[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]45[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]65[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]30[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]47[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]33[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]37[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]20[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]29[/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]16[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]17[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]34[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]25[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]45[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]37[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]32[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]88[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]20[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]35[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]79[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]67[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]154[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]101[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]119[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]96[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]36[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]49[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]45[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]100[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]40[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]54[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]59[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]37[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]92[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]93[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]22[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]113[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]41[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]88[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]38[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]20[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]25[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]117[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]92[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]23[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]53[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl66, bgcolor: #A6A6A6, align: right"][FONT=Calibri]39[/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]61[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]20[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]70[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]42[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl67, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]78[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl68, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]48[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
 [TR]
  [TD="class: xl69, bgcolor: #A6A6A6, align: right"][FONT=Calibri]40[/FONT][/TD]
  [TD="class: xl70, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]51[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl70, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]81[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl70, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]63[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl70, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]15[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl70, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]126[/COLOR][/SIZE][/FONT][/TD]
  [TD="class: xl71, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]24[/COLOR][/SIZE][/FONT][/TD]
 [/TR]
</tbody>[/TABLE]
and here the maximun number I believe, I am not sure, could be 900. the rest is the same.
 
Upvote 0
Try this :-
NB:- The data should start in "B1", Results sheet(2) "A1".
Code: 
[COLOR="Navy"]Sub[/COLOR] MG08Dec49
[COLOR="Navy"]Dim[/COLOR] oMax        [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Rng         [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Dn          [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] nMax        [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Ac          [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Rw          [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] c           [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long[/COLOR]
[COLOR="Navy"]Dim[/COLOR] n           [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long[/COLOR]
[COLOR="Navy"]Dim[/COLOR] nRng        [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Cl          [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] cMax        [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Col         [COLOR="Navy"]As[/COLOR] Double
[COLOR="Navy"]Set[/COLOR] Rng = Range(Range("B1"), Range("B" & Rows.Count).End(xlUp)).Resize(, 6)
oMax = Application.Max(Rng)
Col = Round((-1 + ((1 + (4 * oMax * 2)) ^ (1 / 2))) / 2) + 1
ReDim nray(1 To Rng.Count, 1 To Col + 1)
        ReDim Ray(1 To oMax, 1 To 2)
[COLOR="Navy"]For[/COLOR] n = 1 To oMax
    [COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Dn [COLOR="Navy"]In[/COLOR] Rng
        Ray(n, 1) = n
            [COLOR="Navy"]If[/COLOR] Dn = n [COLOR="Navy"]Then[/COLOR]
            Ray(n, 2) = Ray(n, 2) + 1
    [COLOR="Navy"]End[/COLOR] If
    [COLOR="Navy"]Next[/COLOR] Dn
[COLOR="Navy"]Next[/COLOR] n
[COLOR="Navy"]For[/COLOR] Ac = 0 To Col
    c = 1
    nray(1, Ac + 1) = Ac
        [COLOR="Navy"]For[/COLOR] Rw = 1 To oMax
            nMax = Application.Max(Ray(Rw, 2), nMax)
            Ray(Rw, 2) = IIf(Ray(Rw, 2) = "", 0, Ray(Rw, 2))
            [COLOR="Navy"]If[/COLOR] Ray(Rw, 2) = Ac [COLOR="Navy"]Then[/COLOR]
                c = c + 1
                nray(c, Ac + 1) = Ray(Rw, 1)
            cMax = Application.Max(cMax, c)
            [COLOR="Navy"]End[/COLOR] If
        [COLOR="Navy"]Next[/COLOR] Rw
 [COLOR="Navy"]Next[/COLOR] Ac
[COLOR="Navy"]With[/COLOR] Sheets("Sheet2")
    [COLOR="Navy"]Set[/COLOR] nRng = .Range("A1").Resize(cMax, nMax + 1)
        nRng = nray
          [COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Dn [COLOR="Navy"]In[/COLOR] Range("B1:G1")
                [COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Cl [COLOR="Navy"]In[/COLOR] nRng
                    [COLOR="Navy"]If[/COLOR] Cl = Dn [COLOR="Navy"]Then[/COLOR] Cl.Interior.ColorIndex = 6
                [COLOR="Navy"]Next[/COLOR] Cl
            [COLOR="Navy"]Next[/COLOR] Dn
[COLOR="Navy"]End[/COLOR] With
MsgBox "Run"
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]
Regards Mick
 
Upvote 0
Thanks MickG for read my problems, and because we are talking about frequency; I don't want to post this question as a new, because is the same idea -frequency- but this time maybe less complicate than the others.
I have a results on sheet two, in one column J1:J1952; I need the TOP TEN frequencies only; and the output in sheet 3 A1.[ example if the max-freq. is 25 then down here whatever, after 24 and so on. ]
thanks again.
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question
conditional formatting question
Replies
2
Views
259
kerm007
K
K
  • Question
Excel Pivot table Time Values is not populating same as Source Sheet
Replies
1
Views
370
awoohaw
awoohaw
J
  • Solved
Count Values in sequence
Replies
3
Views
211
myall_blues
myall_blues
imback2nite
  • Solved
VBA help.
2
Replies
10
Views
460
Peter_SSs
Peter_SSs
S
  • Question
Inventory disposal plan
Replies
3
Views
65
Spaceballs_the_fanboy
S

Forum statistics

Threads
1,216,434
Messages
6,130,611
Members
449,584
Latest member
c_clark

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