[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