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 '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