Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions in a worksheet for 2003
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions in a worksheet for 2003
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions in a worksheet for 2003
the 0 does not really matter. start it at 1 then and work from there
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions in a worksheet for 2003
ok so there are 3 complete different games
and there are 130 different game players as you enter the score of each player in the placing column you want excel to automaticly rank the players by scores are any one of the 3 games worth a higher value than the other 2 games please fill in the blanks "SO CONFUSED" wrote: the 0 does not really matter. start it at 1 then and work from there |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions in a worksheet for 2003
no all the same. I just want that if in game 1 someone has a game of 100 and
someone else in game 2 gets a 123 for example that the placing colums changes it so that the 123 is now in first place and the 100 goes down to second or wherever they may be. "Dylan @ UAFC" wrote: ok so there are 3 complete different games and there are 130 different game players as you enter the score of each player in the placing column you want excel to automaticly rank the players by scores are any one of the 3 games worth a higher value than the other 2 games please fill in the blanks "SO CONFUSED" wrote: the 0 does not really matter. start it at 1 then and work from there |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions in a worksheet for 2003
If you are saying that you want the highest score per ROW use a helper
column. Then use small or rank or sort. -- Don Guillett Microsoft MVP Excel SalesAid Software "SO CONFUSED" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How many functions in Excel 2003 | Excel Worksheet Functions | |||
How many functions in Excel 2003 | Excel Worksheet Functions | |||
Functions in Excel 2003 | Excel Worksheet Functions | |||
Excel 2003 Functions | Excel Worksheet Functions | |||
Excel 2003 functions | Excel Discussion (Misc queries) |