Hi Terry,

Try this, you may need to change the ranges.

Put this in I4 and drag down to I10
=H4-ROW()/10^10

Put this in K4 and drag down to K10
=INDEX($A$4:$A$10,(MATCH(LARGE($I$4:$I$10,ROW()-3),$I$4:$I$10,0)))

Put this in L4 and drag down to L10
=LARGE($H$4:$H$10,ROW()-3)

The formula in column I is a helper column and can be hidden.

The other formulae can be moved but you will need to adjust
the 3 to be one less than the row it resides in.

HTH
Martin



"Terry" wrote in message
...
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