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 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. 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.įrom 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.

following this all other members just gain 1 point for attending a match.

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.

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). I would like to create a excel document that automatically updates a league table after entering data.

Fishing planet spreadsheet 2020