P
phillip harrison
Hi there, I've got, what i think it quite a tough problem to crack, I
have some idea of how to go about it but any help would be more than
greatly appreciated.
ok.. what i have is this:
2 columns of data, one starts at C3 and the other at D3, the first
contains 'mean' values and the other 'range' values (im just mentioning
this so that i can refer to and distinguish between the two columns via
these names) The column lenghts, although always equal to each other,
shall vary each time the macro is run.
I then have a matrix, on the y axis is the mean and the range is on the
x axis. The y axis increments in steps of 20 (up to a max of 300) and
the x axis in steps of 10 (up to a max of 600) (i.e. the first cell of
the matrix at the bottom left hand corner will have: bottom line = mean
0, top line = mean 20, left side line = range 0, right side line = range
10)... to try and clarify this incase its still confusing, as you cant
label the actual lines on an excel spreadsheet I have to label the cells
to the left and below our cell in the bottom left hand corner of the
matrix. The left hand cell will contain the number 10 and the bottom
cell will contain the number 5, these as you prob have noticed are half
way between the X and Y increments, becuase as i said before you cant
label the actual lines of cells only the cells themselves which I take
to represent the meridian of the cells.
Ok.. hopefully that makes sense.. thats the setup I have. Now, what i
need to do is this:
Go through each of the mean and range value pairs in the columns and
decide which of the cells they belong to in the matrix, for example if
the mean = 3.48 and the range = 6.4 then i shall put a 1 in the cell
with y value (mean) = 10 and x value (range) = 5, this is because 3.48
is between 0 and 20, and 6.4 is between 0 and 10. If another mean and
range pair fall into the same cell then the 1 needs to be changed to a 2
and so on.
I really hope this makes sense and that someone out there knows how to
do this and can let me know please.
Thank you
Phillip
have some idea of how to go about it but any help would be more than
greatly appreciated.
ok.. what i have is this:
2 columns of data, one starts at C3 and the other at D3, the first
contains 'mean' values and the other 'range' values (im just mentioning
this so that i can refer to and distinguish between the two columns via
these names) The column lenghts, although always equal to each other,
shall vary each time the macro is run.
I then have a matrix, on the y axis is the mean and the range is on the
x axis. The y axis increments in steps of 20 (up to a max of 300) and
the x axis in steps of 10 (up to a max of 600) (i.e. the first cell of
the matrix at the bottom left hand corner will have: bottom line = mean
0, top line = mean 20, left side line = range 0, right side line = range
10)... to try and clarify this incase its still confusing, as you cant
label the actual lines on an excel spreadsheet I have to label the cells
to the left and below our cell in the bottom left hand corner of the
matrix. The left hand cell will contain the number 10 and the bottom
cell will contain the number 5, these as you prob have noticed are half
way between the X and Y increments, becuase as i said before you cant
label the actual lines of cells only the cells themselves which I take
to represent the meridian of the cells.
Ok.. hopefully that makes sense.. thats the setup I have. Now, what i
need to do is this:
Go through each of the mean and range value pairs in the columns and
decide which of the cells they belong to in the matrix, for example if
the mean = 3.48 and the range = 6.4 then i shall put a 1 in the cell
with y value (mean) = 10 and x value (range) = 5, this is because 3.48
is between 0 and 20, and 6.4 is between 0 and 10. If another mean and
range pair fall into the same cell then the 1 needs to be changed to a 2
and so on.
I really hope this makes sense and that someone out there knows how to
do this and can let me know please.
Thank you
Phillip