Thread: Matrix Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rothman
 
Posts: n/a
Default Matrix Question

Okay, I guess it can't be done. Anyone know of any other software that could
help me out?

"Rothman" wrote:

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.