Stumped: Help please, simple

  • Thread starter Thread starter Monte Comeau
  • Start date Start date
M

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.
 
the RANK function is easy. If data are in A1:D9, 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
 
Sorry - I goofed - didn't translate my test sheet cell
labels correctly. Should read =rank(d1,$D$1:$D$9,0)
 
Back
Top