Dynamic Named Range Picking up Cells with Zeros (0s)

**bjnockle** · 09-06-2014, 01:45 PM

Ron Coderre: The formula supplied is now selecting the cells in reserve order instead of only selecting down based on values greater than zero.

Thanks

**Ron Coderre** · 09-06-2014, 01:51 PM

With all the gyrations in your original formula, I wasn't sure what range you wanted to select.
This formula will reference a range that begins at C4 and is the number of cells >0 high

=OFFSET(Chartdata_linked!$C$4,,,COUNTIF(Chartdata_linked!$C$4:$C$613,">0"))

In your example, that would be C4:C10

Does that help?

**bjnockle** · 09-06-2014, 01:59 PM

Ron Coderre: Sorry for the confusion. In the original formula and sample workbook, when you enter 5 in C5, the original formula will select C9:C13 with C11:13 with zero values. Instead, would like the formula adjusted to only select C9:C10 since the cells are not zeros (or greater than zero).

Thanks