Hi Terry,

Your welcome Terry,
The blank column is just a habit of mine. I like keeping
things separated for the visual look, it makes for less
clutter.

Regards
Martin


"Terry" wrote in message
...
Thank you kindly Martin.

I am trying to work it into my spreadsheet.
May I ask what should be in blank "J" column, as you have no mention of
it, but include: "I", "K" and "L" columns.

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