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 '19 at 5:27
  • If you haven't resolved your problem, please share a copy of your spreadsheet, excluding any private or confidential information. Please include an example of a successful outcome. – Tedinoz Dec 6 '19 at 12:14

Your Answer

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