MINS, Match, Index - ignore "0"'s or "-"'s

[albert_de]

I am trying to create a spreadsheet that summarises our Weather Station’s raw data.

But I am struggling with data from the Weather Station that returns a “0” value or “-“ when no data was recorded by the weather station.

The attached Image helps to explain what I am trying to achieve.

Thank you for any direction that Members maybe able to offer me. I really am stuck!

 

[albert_de]

Thank you FormR - your solution ignores 0's perfectly in my Spreadsheet . I appreciate your help.

 

[albert_de]

Thank you etaf for the help that you extended to me as well. You put in a lot of effort for me on possible solutions. People like you are a god send to the less knowledgeable.

 

[etaf]

you are welcome