displaying ranges
 

hi

i am analyzing numbers. i have 6 distinct columns of numbers. each column
has 5 to 7 variables. What I want to do is program each column with its
variables, and have excel spit out all the possible unique combinations of
those numbers

for example:

col1 col2 col3 col4 col5 col6
1 10 21 34 40 11
3 14 23 37 42 14
4 17 28 38 43 18
5 19 30 39 44 20

What I want the spread sheet to do is spit out all the possible *unique*
combinations of those numbers, with only the numbers showing in any of the
columns at anytime that are uniquely assigned to the columns.

if excel cannot do this, if you know of a program that does please let me know

thanks

displaying ranges
 

See your crosspost in Miscellaneous

"iart" wrote in message
...
hi

i am analyzing numbers. i have 6 distinct columns of numbers. each column
has 5 to 7 variables. What I want to do is program each column with its
variables, and have excel spit out all the possible unique combinations of
those numbers

for example:

col1 col2 col3 col4 col5 col6
1 10 21 34 40 11
3 14 23 37 42 14
4 17 28 38 43 18
5 19 30 39 44 20

What I want the spread sheet to do is spit out all the possible *unique*
combinations of those numbers, with only the numbers showing in any of the
columns at anytime that are uniquely assigned to the columns.

if excel cannot do this, if you know of a program that does please let me
know

thanks