Hi Group

Xp Pro
M/S Office 2003

I have a single worksheet where I keep records of a bowls league.

Headings for the columns(row 3) a
Team, Played, Won, Drawn, Lost, +/-, Shot diff', Total points.

A4:A10 are the full team names.
H4:H10 are the Total points.

From above info' is it possible to "automate" this table, when I enter one
or more results?

I have tried the functions "large" and "index", but unable to get the TEAM
NAMES(resulting in "0"), yet I was able to do the Total points column ok!!

Currently I manually enter my results as they are available, then I use
DATA/SORT to give me the desired table.(highest & lowest scores).

TIA

Terry