I wonder if anyone can help me. I have a table of scores with Weeks in columns and Names in rows as follows:


A B C D
Week 1 Week 2 Week 3 Week 4.................Week 33

1 Player 1

2 Player 2

3 Palyer 3

down to player 16

In each column I want to enter the scores for each player each week.

On a separate sheet I would like to write a summary of the scores and at the top I would like it to include the most recent week played, so I need a formula that will return the highest column heading that contains scores (not all the players will have scores entered each week).

So for example if the Sheet is as follows:

A B C D
Week 1 Week 2 Week 3 Week 4.................Week 33

1 Player 1 650 622

2 Player 2 642

3 Palyer 3 678

Then the formular would return "Week 2"

If it was like this

A B C D
Week 1 Week 2 Week 3 Week 4.................Week 33

1 Player 1 650 622 690

2 Player 2 642

3 Palyer 3 678

It would return "Week 3"

PLEASE HELP :-)