Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
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) | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) |