FFF Australian Fishing

Any chance of doing the best 6 total column?

Thanks Lats, I have been trying to nut out how to do it with the spreadsheet, I'll work it out eventually.

So whats the correct score then Matt ?
Something like this I'd reckon jeffish.... TOP 3 so far this year

MR126 596 well done mate
BARRAMICK 592
FLICKIN4EM 546

WITH THE SPEADSHEET :
just add columns to a total in your spreadsheet and you'll be laughing till round 7

But your best 6 fish out of 11 rounds will screw this formula up a bit in the later rounds with upgrades, but will work a treat until we get to round 7 or for those who haven't caught many fish for the entire year

But for the few of us out of the 36 entrants so far this year who are now chasing upgrades you'll have get the calculator out on your smartphone and DIY. Ol school style

Pretty tight up the top noting that there are a few yet to register a 6th fish, and it's now pretty much time for the big girls

1st MR126 596
2nd Barramick 592
3rd Flicken4em 546
4th Sullo 491
5th Lats 471
6th Theodosius 468
7th Edo 461
8th Ivan 436

This is how you do it but you will need 1,2,3,4,5,6. The example only counts the top 3

Thanks Lats, I will have a go at it later this week, I am not using Excel but no doubt it will be similar