Match fishing results and league tables

[gowster88]

Hi All

I would like to create a excel document that automatically updates a league table after entering data.

I wish to create a table for individual fishing matches which I can manually enter the weights of fish caught by each angler (in pounds and ounces). From this, i want the highest weight caught to then automatically gain 10 points (in a separate column), with second place gaining 9 points, third 8 and so on until the tenth person... following this all other members just gain 1 point for attending a match. For the individual match table, i would like the table to auto sort itself so that the winning angler (with the highest weight of fish) is top etc etc.

From the above table, i would like to create a league table which updates automatically following the entering of the weights of fish caught on each match. I would like the leauge table to autmatically add the points for the latest matches, and also the over all total weights of fish caught by each angler. Again, i would like this table to auto sort the rows so that the person with the highest number of points is ranked top of the league etc etc.

I have included a layout that im currently using, but it has no formulas in... I literally manually enter all the data and carry out the maths etc. It looks neat for posting up but is a nightmare to do and very time consuming! If anyone can help then please get in touch. All this may not even be possible for all i know!

Any help with either of the elements would be greatly appreciated! Even more so if someone has a template that is similar!

Many thanks!