Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two columns of data that have repeating values(columns B and D). Both
are the same length. I want to find all the permutations of this data, specifically the values of column D minus column B. What I have done so far is made an array of all of the differences that can exist. My problem is I want to take a value from column 1 of the new array, then a different value from column 2, etc. without duplicating any of the row values. I have started to do this using For...next, however with 50 columns and rows it will be a lot of code to type 50 for...next commands with 50 boolean statements to assure that the data doesn't repeat. Is there a better way to do this or should I start typing ASAP? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Permutations | Excel Worksheet Functions | |||
Permutations of an array element < to a value | Excel Worksheet Functions | |||
Permutations | Excel Worksheet Functions | |||
Permutations | Excel Worksheet Functions | |||
Permutations | Excel Programming |