Hello!
I am using this small array.. but i just want to show numbers that are
not over 50
AND
not UNDER negative 50
.. how could i modify it to work in that way? I'd still like to keep the F114:AS114=0 part of it as well.. :/
={SMALL(IF(F114:AS114=0,AX145,F114:AS114),1)}
Thank you so so much for insight or help on this! Really really appreciate it!!
I am using this small array.. but i just want to show numbers that are
not over 50
AND
not UNDER negative 50
.. how could i modify it to work in that way? I'd still like to keep the F114:AS114=0 part of it as well.. :/
={SMALL(IF(F114:AS114=0,AX145,F114:AS114),1)}
Thank you so so much for insight or help on this! Really really appreciate it!!