How to get range of dynamic column?

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:40 PM GMT


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


©2024 eLuminary LLC. All rights reserved.