C
cqmman
Hello,
I have two arrays. One contains rows of numbers preceeded by a name,
ie.
square, 1,2,5,7,8,4,2
circle, 3,6,2,8,3,5,7
triangle,4,7,3,2,3,3,5
circle,4,7,5,3,2,5,7
The second looks something like this
square,0,1,1,2,0,1,0
circle,1,2,0,0,0,2,2
triangle,0,0,0,1,1,2,2
I want to do a calculation on the rows in teh first based on the
second. ie, apply certain conditions to the 2nd, 3rd and 7th columns of
the first row (square), different calculations on the 4th, and
different calcuations on the rest. And then similar for the other items
in the first array depending on the contents of the second...Oh, the
cell with "square" in it, could be A1 on two seperate sheets (in the
same book) if that makes much difference.
Not much of an idea where to start so can anyone give me any pointers?
Thanks
I have two arrays. One contains rows of numbers preceeded by a name,
ie.
square, 1,2,5,7,8,4,2
circle, 3,6,2,8,3,5,7
triangle,4,7,3,2,3,3,5
circle,4,7,5,3,2,5,7
The second looks something like this
square,0,1,1,2,0,1,0
circle,1,2,0,0,0,2,2
triangle,0,0,0,1,1,2,2
I want to do a calculation on the rows in teh first based on the
second. ie, apply certain conditions to the 2nd, 3rd and 7th columns of
the first row (square), different calculations on the 4th, and
different calcuations on the rest. And then similar for the other items
in the first array depending on the contents of the second...Oh, the
cell with "square" in it, could be A1 on two seperate sheets (in the
same book) if that makes much difference.
Not much of an idea where to start so can anyone give me any pointers?
Thanks