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: 
If you don't want to change the order that they are presently in you can use the LARGE function. It returns the kth largest value. 

Below is a great formula, if you drag it down it will automatically get the second, third and nth largest value from a table of data (in this example the data is between A1 to A10).

```
=LARGE(A1:A10,ROW(A1)-ROW($A$1)+1)

```

You can then match the values with names or corresponding data from the tables using the MATCH and INDEX functions. The example below would fetch the name for each value from the second column.

```
=INDEX($A$1:$B$10,MATCH(cell reference with score or value,$A$1:$B$10,2))

```

Play around with these formulas, they are very convenient for data m
If you have Excel 2007,

Check that your data is continuous, with no blank rows or columns. Click on your scores and then select **'Data - Filter'**

Using the dropdown that the filter creates at the top of your scores column and select **'Number filters - Top ten'**

A **'Top ten Autofilter'** dialog will be displayed, reduce the show 10 to 5 and then click on OK.

---

For earlier versions of Excel add a RANK formula in a new column. Be careful as the scores need to be sorted, usually into descending order. If there are any ties, they will be given the same ranking number and the subsequent rank number will be incremented by the number of ties. (E.g. If there are two scores of 2, ranked as 5. The next score will be ranked as 7, not 6)