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.