Find minimum based on criteria and change output based on if it's the minimum or not.

Copper Contributor

I am trying to use the formula below to find the minimum CTR of campaigns. I've figured out how to get the output of the lowest minimum but now I want the column to only put the lowest minimum value and the other cells I want to put a "NA" or "Not minimum" value.

 

Column BU = Campaign
Column BX = CTR

Screen Shot 2021-03-03 at 8.47.09 AM.png

 

What do I need to do to the formula to get it so the output for example of the first four cells = 
Not Min
Not Min
3.45%
Not Min

Instead of 
3.45%
3.45%

3.45%

3.45%

2 Replies

@avatour 

In row 4:

 

=IF(MINIFS($BX$4:$BX$2058,$BU$4:$BU$2058,$BU4)=$BX4,MINIFS($BX$4:$BX$2058,$BU$4:$BU$2058,$BU4),"Not Min")

 

Fill down.