Formula Help

[ainman]

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.

 

[Bernie Deitrick]

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]

Thank You!

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