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:


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