| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
Thank You!
"Bernie Deitrick" wrote: ainman, A lot depends on how your data table is arranged, but in general, you can assign points using the RANK function: If a high score is better (number or three pointers) =RANK(score,rangewithscores,TRUE) If a low score is better (number of technical fouls) =RANK(score,rangewithscores,FALSE) Along the lines of =RANK(C2,C$2:C$6,TRUE) Then sum up the points, and use another RANK function to rank the results. HTH, Bernie MS Excel MVP "ainman" wrote in message ... I run a Rotisserie Basketball League. There are five teams. Standings are based on 8 categories, with the team with the most stats in one category recieving 5 points, second most stats get 4 points, third most stats get 3 points, fourth gets 2 points, and last place in category gets one point. All eight categories are done this way. I am able to get the stats to excel, but I need a formula to calculate the standings quicker so I will not need to do them manually anymore. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
