![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Separate the digits into 3 combinations | Jasa P | Word VBA | 1 | 08-19-2012 11:04 PM |
![]() |
giocarmine | Word | 1 | 01-22-2012 11:19 AM |
![]() |
JimS378 | Excel | 7 | 05-03-2011 08:20 PM |
Outlook 2007 Saved sent items list only holds the last ten items | david.peake | Outlook | 0 | 06-01-2010 07:27 PM |
Help with nested cylinders and labels | pixmanlajunta | PowerPoint | 0 | 01-18-2010 11:25 AM |