I have two teammates and they each have an index. player 1 is 6.6 and player 2 is 10.2
I need a formula that will take lower index twice and higher index once. add them together and divide by 3
in my spread sheet though, i have several teams and the players are not always listed with the smaller index first. Can a formula decipher which index is smaller and use it twice? or do i have to order them smaller one first?
