I am looking for some help, been fiddling with excel most of last night but not any closer to solving this little problem.
Lets say I have some test results, based on the % achieved you get some points (which will be used later in combination with other test results).
Any score under 60%...
Just wondered if anyone knew how to get around this!
I suspect there's going to be some complicated IF Formula's here :/ but not quite sure how to make this work.
The scenario is two fold:
1) I need to rank a group of people - however in this way -
More than 1 person can score...