Hi,

Thanks for that info...I will give that a go. The link you specified below
doesnt seem to work.

kind regards

"Gary Brown" wrote:


If you have your original league table with 2 columns before, the first
used to rank the points + the row number/100 to allow for individuals
on joint points, then a second column ranking the first. Then in a new
table, where you have numbers down the left (for the number of players
in the league) and then put a vlookup for all of the columns in your
table. When you then alter the original tables points values. The new
table automatically recalculates.

See attached zipped spreadsheet


+-------------------------------------------------------------------+
|Filename: Example.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4137 |
+-------------------------------------------------------------------+

--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=494590