Question: I run a small golf eclectic with excel. One of the things we have is a points system. I would like to get the 5 highest points scored over the season and have them ranked from 1 (being the highest points scored) to 5.

My knowledge of excel "sums" goes only a wee bit further than add and subtract.

Thanks!

Answer: 
Given a list of numbers in A1 to A10, you can work out their 'Rank' relative to each other by using 'RANK'.

e.g.

```
RANK(A1,A1:A6,0)

```

RANK(cell, list of cells to check against, order)

For order, 0 = descending.

From there you can work out which one is first pragmatically.
If you want to use the LARGE Function as described above, make sure you put the same range in the list for each of the LARGE functions. That is, change =LARGE(A1:A10,ROW(A1)-ROW($A$1)+1) to =LARGE(A$1:A$10,ROW(A1)-ROW($A$1)+1) or you will get some strange incorrect results