I need to take scores from 6 candidates that their scores or totaled in a row. I need to find the 'points less than the highest score' in that array and also I need to find a 'percentage less than the highest score'. I have attached a clip of the sheet that I am working on a thanks in advance for the help.
Dave
<tbody>
</tbody><colgroup><col><col><col><col><col><col span="2"><col><col span="2"><col></colgroup>
Dave
total points | 25 | total score | 7 | 7.5 | 8.7 | 7.1 | 5.2 | 7.5 | ||
POINTS LESS THAN HIGHEST | 0 | 0 | 0 | 0 | 0 | 0 | ||||
% LESS THAN HIGH SCORE | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% |
<tbody>
</tbody><colgroup><col><col><col><col><col><col span="2"><col><col span="2"><col></colgroup>