Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
As always, my knowledge is limited; however, this time doubly so.
I have a matrix of numbers like so: K L M N O 1st # 2nd # 3rd # 4th # 5th # 5 1 0 0 0 1 5 0 0 0 1 5 6 1 0 0 3 3 6 4 0 1 3 2 3 I'd like to list all possible five-numbered "combinations" using the following rule: You can only pick one number from each column AND row. Any way of doing this? Thanks yet again, very sincerely. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Matrix question | Excel Worksheet Functions | |||
Matrix Problem | Excel Discussion (Misc queries) | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Matrix calculation | Excel Discussion (Misc queries) | |||
How to identify entries in a matrix also present in another list | Excel Worksheet Functions |