I have a sheet in Excel that shows success of students in certain parts of the exam (tests, presentations, final exam etc.). I need to calculate some statistical data and the problem is that for some tests they have three tries, only the highest points count and I do not have the "max" column. I need to count how many got more than 15 points in best attempt, how many between 10 and 14,9, etc. Also I need to see how many students had at least one try (based on a non-empty field or >=0).
Table looks like this (one part):
So, from this I would need to extract in one cell that number of max per-row values >=15 is 2 (Belle at 15,5 and Clara at 18), and that total students ever attempted at least once is 3.
I repeat that I cannot add the separate column where I would calculate max values because it is an official document, and adding one to another sheet is not a preferred solutions.
I tried some subtotal and offset combinations, but without much sucess. I use MS Excel 2013, other colleagues use 2007 and 2010.