WOW! Thanks for all the helpful suggestions. I'll share these with him and
see if they work for him.

Harlan,
I get paid to make sure his computer keeps working, not to come up with the
answers to squirrely problems like these. :) Of course I will tell him where
the answers came from. I would never take credit for something I don't quite
understand. :)

Thanks again, everybody, for your help!

Jennifer


"Jennifer Q" wrote in message
...
A user posed this problem and I have no idea how to help him out. Any
suggestions or advice?

Thanks in advance for your help.

Jennifer Q

~~~~~~~
Suppose that I have a matrix that has say 13 rows and 6 columns. I wish
to write an EXCEL program that takes 5 rows at a time and computes the sum
of each column for the resulting matrix. The program is to record the
maximum of these column sums along with the rows for which the computation
was made. The program is to cycle through all 1287 possible combinations
of five rows repeating the column sum computations and recordings as
indicated above.



An example matrix is shown below:



| A | B | C | D | E | F

1 | 1 2 1 1 4 8

2 | 5 8 7 4 1 5

3 | 9 6 2 9 9 6

4 | 6 5 5 7 7 7

5 | 11 13 6 3 3 2

6 | 8 7 11 2 5 10

7 | 3 12 4 10 8 4

8 | 4 1 8 12 12 11

9 | 12 3 10 8 10 1

10| 7 9 13 13 6 3

11| 10 10 12 11 2 13

12| 2 4 9 6 13 12

13| 13 11 3 5 11 9