I would like to compute average scores over top k exams. That's why I need to get top k scores. There is a large function in excel, but I am not even able to execute it in a simple list in excel because it throws an error message. I also attached the screenshot of that situation. Any helps will be appreciated.
The solution is pretty simple:
Write the formula using
; as separator instead of
Excel is weird as regarding the argument separator, deciding on which of the two to use, depending on where in the world is your computer situated. It has no relation to the language your computer uses.
(Another weirdo from Microsoft that was never corrected in decades.)