Nested Looping all combinations of four items
Hello
I have four cells (A,B,C,D) and I am testing all cells against each other.
So, I am testing AB, AC, AD, BC, BD, CD
In columns 1-6 I have the test results. (see below)
In columns 11-14 I wish to create a summery for A, B, C, D
I am looking for any results greater than the absolute value of
1.5. If the result is positive then it indicates that the first item in the
test is greater than the second item A > B, for AB, if the result
is negative then it indicates the second item in the test is greater
than the first item, B > A for AB
So, in the example below
A > B
B > D
C > AD
D > A
So, what I need to do is create a (nested) loop that will go through these
six columns of test results and create 4 summary columns.
Any help is much appreciated,
TIA,
Lance
Here is the summary I would like to create
C11 C12 C13 C14
R1 A B C D
R2 B D AD A
Header and Intial test results for A B C D
R1 AB AC AD BC BD CD
R2 1.6 -1.6 -1.6 0 1.6 1.6
|