Good day All,
i have a excel sheet with data as follows:
<tbody>
</tbody>
User will input 3 fields, like
<tbody>
</tbody>accordingly sort the columns "severity-1" (ie. >=6) and "severity-2" (ie. >=8), then filter the rows only with the sum of amount cap under 150, like the given below results.
results should be like this.
<tbody>
</tbody>
and it should tell your amount cap is "150", but we are showing less "20".
thanks in advance.
i have a excel sheet with data as follows:
Name | Amount | Severity-1 | Severity-2 |
Client1 | 45 | 4 | 6 |
Client2 | 80 | 7 | 8 |
Client3 | 65 | 5 | 6 |
Client4 | 70 | 4 | 5 |
Client5 | 90 | 6 | 9 |
Client6 | 35 | 8 | 7 |
Client7 | 50 | 6 | 8 |
Client8 | 60 | 5 | 7 |
Client9 | 20 | 8 | 6 |
Client10 | 90 | 7 | 5 |
<tbody>
</tbody>
User will input 3 fields, like
Severity-1 | >=6 |
Severity-2 | >=8 |
Amount Cap | 150 |
<tbody>
</tbody>
results should be like this.
Name | Amount | Severity-1 | Severity-2 |
Client2 | 80 | 7 | 8 |
Client7 | 50 | 6 | 8 |
<tbody>
</tbody>
and it should tell your amount cap is "150", but we are showing less "20".
thanks in advance.