Stumped: Help please, simple

[Monte Comeau]

Hi All,

I have four columns

1: HOLE
2: GROUP A SCORE AVERAGE
3: GROUP B SCORE AVERAGE
4: AVERAGE SCORE DIFFERENCE

In column 5, I would like to rank each hole (row) from 1-9, with the highest
average score difference being ranked 1, and so on down to the 9th ranked
hole.

What function do I use to do this? I have tried MAX(range,1) then
MAX(range,2) etc and that does not work. The RANK function is confusing to
me. Any ideas.

Thanks in advance to any help.

 

[hcj]

the RANK function is easy. If data are in A19, in E1
use =rank(a1,$D$1:$D$9,0), and copy this down to E9. The
0 argument in the function causes the rank function to
rank in order of descending value, as you want to do. If
you want to rank the other way, say low hole score ranks
first, then use any non-zero value for the argument. Note
that the data reference uses absolute terms.

HTH, hcj

 

[hcj]

Sorry - I goofed - didn't translate my test sheet cell
labels correctly. Should read =rank(d1,$D$1:$D$9,0)

 

[Monte Comeau]

Thanks