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

%3CLINGO-SUB%20id%3D%22lingo-sub-2181838%22%20slang%3D%22en-US%22%3EFind%20minimum%20based%20on%20criteria%20and%20change%20output%20based%20on%20if%20it's%20the%20minimum%20or%20not.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2181838%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20use%20the%20formula%20below%20to%20find%20the%20minimum%20CTR%20of%20campaigns.%20I've%20figured%20out%20how%20to%20get%20the%20output%20of%20the%20lowest%20minimum%20but%20now%20I%20want%20the%20column%20to%20only%20put%20the%20lowest%20minimum%20value%20and%20the%20other%20cells%20I%20want%20to%20put%20a%20%22NA%22%20or%20%22Not%20minimum%22%20value.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%20BU%20%3D%20Campaign%3CBR%20%2F%3EColumn%20BX%20%3D%20CTR%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202021-03-03%20at%208.47.09%20AM.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F260508i6B9F762465261A62%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202021-03-03%20at%208.47.09%20AM.png%22%20alt%3D%22Screen%20Shot%202021-03-03%20at%208.47.09%20AM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20do%20I%20need%20to%20do%20to%20the%20formula%20to%20get%20it%20so%20the%20output%20for%20example%20of%20the%20first%20four%20cells%20%3D%26nbsp%3B%3CBR%20%2F%3ENot%20Min%3CBR%20%2F%3ENot%20Min%3CBR%20%2F%3E3.45%25%3CBR%20%2F%3ENot%20Min%3CBR%20%2F%3E%3CBR%20%2F%3EInstead%20of%26nbsp%3B%3CBR%20%2F%3E3.45%25%3CBR%20%2F%3E3.45%25%3C%2FP%3E%3CP%3E3.45%25%3C%2FP%3E%3CP%3E3.45%25%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2181838%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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.