Mar 03 2021 06:59 AM
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
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%
Mar 03 2021 07:46 AM
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.
Mar 03 2021 08:19 AM
@Hans Vogelaar Thank you!!