Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying date ranges for multiple years | Charts and Charting in Excel | |||
Displaying percentage in ranges in pivot table | Excel Worksheet Functions | |||
displaying ranges | Excel Discussion (Misc queries) | |||
Excel Vba - Comparing 2 ranges of data and displaying result in another worksheet | Excel Programming | |||
named ranges - changing ranges with month selected | Excel Programming |