B
Ben
Thanks to Bob I have a formula which ranks my team players in position
order...(see formula below)...
=IF(COUNTIF($D$2:$D$706,D2)>1,"T","")&COUNTA($D$2:$D$706)-SUM(IF(D2>$D$2:$D$706,1/COUNTIF($D$2:$D$706,$D$2:$D$706)))-1
I now need a formula which calculates how many positions a player has moved
up or down from the previous week ie:
Club Player Name Points Position Pos Gained or Lost
Fremantle SANDILANDS,Aaron 1 (would like an arrow up
or
down here) Up 4
Western Bulldogs CROSS,Daniel T2 down 1
West Coast KERR,Daniel T2 down 2
Western Bulldogs JOHNSON,Brad 3 down 2
order...(see formula below)...
=IF(COUNTIF($D$2:$D$706,D2)>1,"T","")&COUNTA($D$2:$D$706)-SUM(IF(D2>$D$2:$D$706,1/COUNTIF($D$2:$D$706,$D$2:$D$706)))-1
I now need a formula which calculates how many positions a player has moved
up or down from the previous week ie:
Club Player Name Points Position Pos Gained or Lost
Fremantle SANDILANDS,Aaron 1 (would like an arrow up
or
down here) Up 4
Western Bulldogs CROSS,Daniel T2 down 1
West Coast KERR,Daniel T2 down 2
Western Bulldogs JOHNSON,Brad 3 down 2