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.

enter image description here

  • 2
    Is the comma the correct argument separator for your Windows Regional Settings? Some use a semicolon. eg: =large(a2:a9;1) – Ron Rosenfeld Jun 10 at 19:53
  • 1
    @RonRosenfeld That must be the issue. I think you should post it as an answer. – Reddy Lutonadio Jun 10 at 19:55
  • Thank you all for your quick responses! – mgokhanbakal Jun 10 at 20:04

The solution is pretty simple: Write the formula using ; as separator instead of , like this: =LARGE(A2:A9;1).

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.)

  • Thanks a lot. What a silly problem. – mgokhanbakal Jun 10 at 20:03
  • 2
    I would call it criminal rather than silly, because it means that communicating spreadsheets internationally is impossible without some manipulations. – harrymc Jun 10 at 20:10
  • I do respect your opinion. – mgokhanbakal Jun 10 at 20:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.