• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

getting three table base on array

V

vicktor schausberger

Member
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,P2:P13)} this is in the column Q
--- {=frequency(B4:G5,P2:P13)}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.
 

Attachments

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 ?
 
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.
 
You must log in or register to reply here.
Back
Top