dynamic range with index

[dmheller]

All,
I have created a name in the name manager I called it "l3nox". The data can be pulled how ever I want it to so the amount always changes. I then graph the data based on the name I have defined. Here is the equation for my name.
=Sheet1!$F$6:INDEX(Sheet1!$F:$F,COUNT(Sheet1!$F:$F))
For some reason, I am always 5 cells above the last value. Any advice would be great.
thanks

 

[Momentman]

For example, you have 20 cells returned by the COUNT, starting at F6, you should end at F25, but your formula is returning F6 to F20

What you need simply is
=Sheet1!$F$6:INDEX(Sheet1!$F:$F,COUNT(Sheet1!$F:$F)+5) "5 because you are starting at F6"