0

I am trying to find the smallest positive value for multiple ranges. Essentially I want to find it in column J without including cells J7,J14,J21,J28 and J35.

picture reference

This is what I have so far:

=ArrayFormula(MIN(IF($J$2:$J$6>0,IF($J$8:$J$13>0,IF($J$15:$J$20>0,IF(!$J$22:$J$27>0,IF($J$29:$J$34>0,'$J$2:$J$35)))))))

The value returned should be 2 but I am getting 0. Do all of the cells have to be populated? I appreciate any help.

  • What is the result of =MIN($J$2:$J$35)? – Reddy Lutonadio Nov 2 at 5:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy