Thread: Score Calculation

Hello, Apprecaite if you could provide helps on how to do a formula in excel on the following:

What i want is to compare a score of 2 team and the team who got the higher score will get 1 points, if the 2 team score are the same then each will get 0.5pt

Please advice how to automate this .

Apprecaited.

Please see the attached sample file

Hi ,

Please find the attached excel sheet with the required formula..

While creating the formula I got confused as D is not the highest still it got 1 point....

Check whether the formula meets your need

Hi Shijesh,

Thanks for the help. however this is not what I wanted. sorry I might not express it right.

What I want is to enable me to find the highest score between grouping and identify the highest score among the 2 group.

eg.

Grouping 1 consist of Team A & Team D, the formula should able to look for the grouping first then look for the score and see which one is higher. if Team A got a higher score, then Team A will get 1 point and Team D will get 0. however if the score are the same then each team will get 0.5 points.

Hope this clarify and appreciate your help.

Regards

thank you oldman, this is exactly what i need.. many thanks

Hello,

I need an advice. I would like to rank a score sheet where there are 2 condition. 1). is the total points and 2). is the total score.

I would like to know how to do it in excel where I can rank it with these 2 condition.

Attached please see the sample.

Many Thanks
Ray