Hello Everyone

I am having some trouble with the OFFSET function for a dynamic range for a chart. I need a way to count the number of cells to the next blank cell however I need the count to start from the same cell as the reference in the first part of the offset.

Here is my formula so far

=MonthlyBDCalcs!$D$1:$J$1,OFFSET(INDEX(MonthlyBDCalcs!$C$2:$C$54,MATCH(MonthlyBDCalcs!$P$2,MonthlyBDCalcs!$C$2:$C$54,0)),MATCH(TRUE,INDEX(ISBLANK(MonthlyBDCalcs!$C$2:$C$54),0,0),0)-1,1,-4,7)

Thanks in advance for the responses unfortunately I can not post the workbook