Hi,

based on data users enter, the data is summarised into a tables.
Please note the totalmoney column will be a


Summary table
emp cat1 cat2 cat3 Totalmoney cat4
bob
graham
fred
gary
john
jo
bloggs



league table
emp| Total| Position|
bob| 12|
gra| 19| 3rd|
fred| 30| 2nd|
gary| 20|
john| 15|
jo| 17|
bloggs| 35| 1st|

(hope the table comes out correct)

Based on the summary table i have totalled up each row, see league
table.
What i want to happen is the position column to to be updated
automatically, to say 1st, 2nd and 3rd.
The users are going enter data on a daily basis, so if the position
changed dynamically it would be ideal.
I can't work out how to do the formula, so I get dynamic results.

Please help

If you need more information let me know.

Thanks


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=571715