Automatically order totals in columns and help with data units.

[ScampsDad]

Hello folks,

Like quite a few of the thread results in the forum I am trying to create a spreadsheet for a fishing clubs website. I have the basics all set up but would like to perform a couple of tweaks to finalize it.

I will attach the a screenshot and the Excel file to this post for info.

The two functions I'd like to add are as follows.....

1: Make the rows order automatically according to the total at the end of the row. In other words row with highest total to position one and so on.

2: The column figures calculate in decimal units and I would like to change these to work in pounds and ounces, whole numbers and 16ths where one pound equals 16 ounces.

I hope this makes sense but if not just holla!

Quick edit, the two columns titled Fish 1 and Fish 2 represent the two types of fish species to be included. Others may be added or taken away from time to time.


Many thanks, Chris