dynamic ranges with blanks

[dmheller]

All,
Trying to make so graphs with dynamic ranges using name manager. should be easy but I am missing something. I could fill all blanks In with 0 and it works but not without it.
Here is what I have
column B is a date June 2018- now and it always grows with each new day
Column G-U is a number from a sample but happens every 2 weeks so there are blanks.
Column C-F are numbers as well one for every day
I want dynamic ranges for all columns
Here is what I did
for the date
='Outfall 1 input'!$B$5:INDEX('Outfall 1 input'!$B:$B,COUNT('Outfall 1 input'!$B:$B)+5)
for c-f one for each
='Outfall 1 input'!$E$5:INDEX('Outfall 1 input'!$E:$E,COUNT('Outfall 1 input'!$E:$E)+5)
for g-u one for each
='Outfall 1 input'!$G$5:INDEX('Outfall 1 input'!$G:$G,COUNT('Outfall 1 input'!$B:$B)+5)
g-u doesn't work due to blanks. Any help would b great.
thanks

 

[Jeffrey Mahoney]

Please try using a formula like this:
=OFFSET($B$4,1,0,match(1e+300,$B:$B)-row($B$4),1)

This will find the last number in the set and include any blanks within the set.

Jeff