andersen_yunan
New Member
- Joined
- Feb 7, 2018
- Messages
- 36
Hi,
Is there any way that I could return the value in a range with given certain condition. For instance:
<tbody>
</tbody>
Thanks in Advance!
Is there any way that I could return the value in a range with given certain condition. For instance:
Name | Class | Score |
Ali | A | 89 |
Alvin | B | 78 |
Barry | C | 23 |
Cynthia | A | #N/A |
Derry | C | 77 |
Kalvin | B | #N/A |
Ricky | A | 68 |
If Less Than 80, | ||
Name | Class | Score |
Alvin | B | 78 |
Barry | C | 23 |
Derry | C | 77 |
Ricky | A | 68 |
<tbody>
</tbody>
Thanks in Advance!