polarisking
Member
Range A2:A6 contains an integer value
Range B2:B6 contains a blank or N value
The objective is to highlight the cell in Range A2:A6 having the minimum value, but ONLY using those cells in Col A where its corresponding Test value is blank. So, in this example, the result of the formula s/b 2 since the value of 1 is excluded based on a Test value of N.
Thanks in advance.
Range B2:B6 contains a blank or N value
The objective is to highlight the cell in Range A2:A6 having the minimum value, but ONLY using those cells in Col A where its corresponding Test value is blank. So, in this example, the result of the formula s/b 2 since the value of 1 is excluded based on a Test value of N.
Thanks in advance.
Value | Test |
---|---|
1 | N |
2 | |
3 | |
4 | |
5 |