Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-30-2012, 08:13 AM
lhoffmeyer lhoffmeyer is offline Nested Looping all combinations of four items Windows 7 64bit Nested Looping all combinations of four items Office 2010 64bit
Novice
Nested Looping all combinations of four items
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Separate the digits into 3 combinations Jasa P Word VBA 1 08-19-2012 11:04 PM
Nested Looping all combinations of four items numbered nested list giocarmine Word 1 01-22-2012 11:19 AM
Nested Looping all combinations of four items Nested IFs 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft