Formula Help
 

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.

Formula Help
 

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.

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.