Hey hope someone can help
I have a very limited knowledge of macro and the developer section but here is what i am trying to achieve.
My dad runs a series of fishing matches thorughout the year and wants to create a leaderboard after each match.
It is a total of 12 matches with each anglers best eight weight cathces counting toward the total weight series.
I am trying to achieve something like below with the best 8 weight series calculated in lbs & oz
as an example 5.12 is 5lb 2oz
So i guess i need a formula or macro that selects the 8 highest weights then adds them up with an equation that every 16 oz = 1lb.
so for example currently if i added 5.12 + 51.02 + 23.04 excel will give a total of 79.18. adding these together in lb and ozs actually gives 80lb 2oz
Hope the above makes sense what i am trying to achieve and hope someone can help
Cheers Glen
I have a very limited knowledge of macro and the developer section but here is what i am trying to achieve.
My dad runs a series of fishing matches thorughout the year and wants to create a leaderboard after each match.
It is a total of 12 matches with each anglers best eight weight cathces counting toward the total weight series.
I am trying to achieve something like below with the best 8 weight series calculated in lbs & oz
as an example 5.12 is 5lb 2oz
So i guess i need a formula or macro that selects the 8 highest weights then adds them up with an equation that every 16 oz = 1lb.
so for example currently if i added 5.12 + 51.02 + 23.04 excel will give a total of 79.18. adding these together in lb and ozs actually gives 80lb 2oz
Hope the above makes sense what i am trying to achieve and hope someone can help
Cheers Glen