I have a list of order numbers in column A, in column B I have a list of corresponding %s (from a formula)
I want to create a list of all the PO numbers that haven’t hit between 95 & 105 (for example, these would be in a cell so I could change them) basically a list of all the PO numbers that haven’t hit target
<tbody>
</tbody>
<tbody>
</tbody>
So the"list" would be,
300
303
306
as all these havent hit target
I want to create a list of all the PO numbers that haven’t hit between 95 & 105 (for example, these would be in a cell so I could change them) basically a list of all the PO numbers that haven’t hit target
Lower Value | Upper Value |
95.00 | 105.00 |
<tbody>
</tbody>
A | B |
PO NO. | % |
300 | 90 |
301 | 100 |
302 | 102 |
303 | 106 |
304 | 96 |
305 | 99 |
306 | 83 |
<tbody>
</tbody>
So the"list" would be,
300
303
306
as all these havent hit target