How to calculate the highest value

[Bigtone09]

Hi

This maybe the simplest question ever but it has me stumped. I have a league chart i use for my local fishing club. how do i work our who lies at the top position when the points we use are the same. In the past the total weight was the deciding factor but i have no idea how to do the formulae for this.

Hopefully I have attached the file for someone to look at

[shg]

Welcome to the board.

Wouldn't that be a question for the club? Or is weight supposed to be the tiebreaker for points?

[Bigtone09]

Hi Yes it is just to decide as a tie breaker.

[CAntosh]

It isn't pretty, but I think the formula below will work. It adds a fractional total based on weight to break any existing ties. You can use formatting to get rid of the visible decimals. The value will show 6, but in actuality it'll be 6.000079. Try the following in C4, enter it with Ctrl + Shift + Enter instead of enter, then fill down.

=IFERROR(SUM(D4:CF4*(MOD(COLUMN(D4:CF4),3)=0))+1/(1000*(SUM(D4:CF4*(MOD(COLUMN(D4:CF4),3)=1))+(SUM(D4:CF4*(MOD(COLUMN(D4:CF4),3)=2))/16))),SUM(D4:CF4*(MOD(COLUMN(D4:CF4),3)=0)))