can't really understand the structure of the col as you are
explaining it
first problem is the 0, how can game 1 be 0,1,2,3
there is a big dif in a formula that starts with 0.
Do you have to 0 what is the signifigance

"SO CONFUSED" wrote:

my workshee looks like this below:
Game 1 PLACING Game 2 PLACING Game 3 PLACING
0 63 3 60 6 57
1 62 4 59 7 56
2 61 5 58 8 55

and so on:

But if say game 1 down the page came in at 73 and was higher that the others
then i want all the placings to change into their new placings of 2 3 4 etc.
Game 1 is I colum Game 1 Placing is J Colum Game 2 is K COlum Game 2 Placing
is L COlum and game 3 is M colum with the game 3 placing in N Colum from
number 1 to 130 in all colums. I need it to be in the highest to lowest order
of game 1 2 and 3 not just each game.

hope someone can help.