View Single Post
 
Old 11-30-2012, 08:13 AM
lhoffmeyer lhoffmeyer is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Nov 2012
Posts: 2
lhoffmeyer is on a distinguished road
Default 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
Reply With Quote