Hi Everyone.
Maybe you can help me with this question.
I have here an example with this range of data.
Data below is the RAW.
What I want to do is to get the Overall Score from the Unique Column which is the Description and Month containing what Range there Grades are. So for Instance, I have 98.5% on Math for July. So the Score would be 4.
Description and Month are just a sample. This could be a whole year (January - December) with lots of Description entered. So the Data below is just a sample of what I want to get the formula.
<tbody>
</tbody>
Maybe you can help me with this question.
I have here an example with this range of data.
Data below is the RAW.
What I want to do is to get the Overall Score from the Unique Column which is the Description and Month containing what Range there Grades are. So for Instance, I have 98.5% on Math for July. So the Score would be 4.
Description and Month are just a sample. This could be a whole year (January - December) with lots of Description entered. So the Data below is just a sample of what I want to get the formula.
UID | Description | Month | From | To | Overall Score | |||
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> | July | 99% | 99999% | 5 | |||
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> | July | 97.5% | 98.99% | 4 | |||
MathJuly |
<tbody> </tbody><colgroup><col></colgroup> | July | 95% | 97.49% | 3 | |||
MathJuly |
<tbody> </tbody><colgroup><col></colgroup> | July | 90% | 94.99% | 2 | |||
MathJuly |
<tbody> </tbody><colgroup><col></colgroup> | July | 0% | 89.99% | 1 | |||
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> | August | 99% | 99999% | 5 | |||
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> | August | 97.5% | 98.99% | 4 | |||
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> | August | 95% | 97.49% | 3 | |||
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> | August | 90% | 94.99% | 2 | |||
<tbody> </tbody><colgroup><col></colgroup> |
<tbody> </tbody><colgroup><col></colgroup> | August | 0% | 89.99% | 1 |
<tbody>
</tbody>