Search code examples
excelchartsexcel-2007offset

Offset in Excel 2007 only goes to certain point

In Excel 2007 my formula for offset is not collecting all of my data. The data will be going into an excel chart I want the formula to collect from G28 to G200, but it stops at G111. Here is the full formula:

=OFFSET(TIJ!$G$28,0,0,COUNT(TIJ!$G$28:$G$200),1)

Any help is much appreciated.

Best, Drew

Solution

  • To find a list of data points that are on going from a certain point (in this can G28). The equation also only surrounds relevant information in the excel spread sheet to a chart.

    =INDEX(Sheetname!$X:$X,Y):INDEX(TIJ!$X:$X,MATCH(1E+99,TIJ!$X:$X))

    X= is the column used

    Y= is the row starting point