This is a follow up to a question I asked here last week. I need to get the lowest value of odd numbered rows only, so I'm using the code you suggested:
That's working great, thanks.
My new problem is that I'm using dynamic data, so the range changes each time. It varies from B1:B8 up to B1:36. If the range is less than 36, the formula returns zero as the lowest value.
How can I get the formula to ignore the empty cells?
I assume that a zero value wouldn¡¯t be allowed anyway so in that situation
would resolve it ¨C if a zero IS valid then
would do it