Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Combinatorics
Hi all,
instead of reenventing the wheel I turn to this group with my case: assume a single column consisting of 20 cells; now, 11 cells contain the number 1, others are empty. What I'm looking for is an elegant way of elaborating all possible combinations of these 11 pieces as how they can be scattered throughout 20 empty cells. Mind you, this could be done by hand (ahhhhh), but a few combinations could be ommitted simply by mistake, and to accomplish this would be a real drudgery; that's why I'm looking for an algorithm to have this done for me. Any ideas? Mac. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Combinatorics | Excel Worksheet Functions | |||
Search for a column based on the column header and then past data from it to another column in another workbook | Excel Programming | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Programming | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
How can i have all alike product codes in column A be matched with like cities in column B and then add the totals that are in column C | Excel Programming |