#### polarisking

##### Member

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 |