getting three table base on array

[vicktor schausberger]

Hello everybody.
FIRST, I assume this is the right forum, I mean V B A MACROS; I understand chandoo have also another forum for EXCEL question where the "FORMULAS", and "FUNCTION" ARE WHAT YOU EXPECT, so here, in this forum "VBA MACROS" I EXPECT A " C O D E ".

second, I understand that more I help, more help I will get, like upload a file with callouts to explain every idea.

NOW MY REQUEST:
I have a array B2:G23 populate with randbetween (1,12), and at Q2:T13 the results I get by {=frequency(B3:G5,P213)} this is in the column Q
--- {=frequency(B4:G5,P213)}this is in the column R and so on; all this results is what I call "table of ranges 3" I mean the frequency go 3 by 3; I would like to get a table of ranges 4 and table of ranges 5.
Like I said this is the forum VBA MACROS I really appreciate a code, to see how the loop ideas are apply to the frequency, see the file.

thanks for reading this.
see you soon.

 

[Hui]

Vicktor

Telling us that you WANT Code to me is like a Red Flag to a Bull.
I look at your problem and I see Data Table!

A few questions first

Q1. Is Row 1
[1] [2] [3] [4] [5] [6]
Data or Headers?

Q2. Why in the 3-5 do you not include 1-3 and 2-4 as they are both rows of 3?

Q3. Do you want to keep going from 3 to 4 to 5 to N-1 Rows?

Q4. Is there always 6 columns or can there be less/more?

Now How do I structure this as a data table ?

 

[vicktor schausberger]

thanks Hui, I like your sense of humor.
A1. It is not a data, A2. this is the first part of the problem, so in part two I will check where 1 was on 3-5.
A3. yes. A4. always A5. "table" is just a name I made it up for illustration purpose only.
and now there are more questions:
column P the bin, will be always 12?. Answer. NO, could be 1 to 36 or 1 to 53.
the array also could be B2:G1000 or more.
and of course if the example array is 6x23 and the answer is 6x20 because the range is 3 in the first place
then by math if the array increase and the range increase the rest also.

 

[vicktor schausberger]

I really would like to hear something about this. I am still here.