Ranking of players

I have a spreadsheet that keeps golf scores for 15 teams with 5 players per
team. On the second page I would like to keep up with all the scores
starting with the lowest score first. I would like this to happen as I enter
the scorces on the first page. Can this be done??

Have a look at different ways of ranking data - here's a link to Chip
Pearson's site:

http://www.cpearson.com/excel/rank.htm

Hope this helps.

Pete