Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can excel list combinations
Hi there All
Can anyone help me ? I am trying to find a way of...... Example 1,2,3,4,5,6 I want to write a formular that will list in the spreadsheet the combinations of say 3s. The answer to this would be: 123 - 124 - 125 - 126 - 134 - 135 - 136 - 145 - 146 - 156 234 - 235 - 236 -245 - 246 - 256 - 345 -346 - 356 - 456 I have tried using COMBIN but can only seem to get a total ie COMBIN (6,3) ans 20 Can excel list these combinations ? I'm not sure Thanks in advance BOB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can excel list the possible combinations from a range of cells | Excel Worksheet Functions | |||
List combinations of a range | Excel Discussion (Misc queries) | |||
Excel combinations from groups | Excel Discussion (Misc queries) | |||
Need combinations of values from a list to add up to a specific Va | Excel Worksheet Functions | |||
Generating excel combinations | Excel Discussion (Misc queries) |