Hi All,
I am trying to automate a chart in a basic spreadsheet and what I normally do is set the data range from say A2:A980 but I only have data in about the first 250 cells in that column.
I can locate the last cell with data by using the Address function [i.e. =ADDRESS(MATCH(E2,B:B,0),COLUMN(B2)) - Note E2 is the last figure value in the row B]. Col A is the Date, Col B is the values which are sporadic.
In the attached example I use the formula to get the values into the chart '=Sheet1!$A$1:$B$260'
What I would like to do is substitute $B$260 with an address function so If i put data in after B260 it will be picked up so the formulae may look something like this???
'=Sheet1!$A$1:ADDRESS(MATCH(B1,A:A,0),COLUMN(A2))'
Appreciate any advice
Cheers Tony
Bookmarks