I am trying to find a formula that will find the smallest value that is not a zero and report it. However, the data from that I want to find the smallest value from is not all in the same range. For example, the data is in the range B11:B13,B20:B22,B32:B34 ect. I appreciate the help.
Maybe this
=MIN(IF(B11:B34>0,B11:B34))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Great! That worked! thanks. Maybe you could help me with one more question. I want to count that same data range and see how many values are below the value in D5 while still ignoring zeros.
Try this one
=COUNTIFS(B11:B34,">0",B11:B34,"<"&D5)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks