hi all,
you've been very helpful for answering my last questions, but this one has popped up and i dont understand very much of it ( i found the code somewhere in the forums and thought it would be useful )
=INDEX(Results!A:A,MATCH(9.99999999999999E+307,Results!A:A),1)*1000
this will return the value of the cell in the last row of the Column "A"
is it possible to include some type of modification to this code to make it find the last value, but search no further than say 500 rows down the column ?
and also how to make it return the last cell's value between 500-1000
it'd be very handy to have for multiple values on the same column, as i have large amounts of data divided into sections, and would like a report to include the last entry for each section on a page
thanks everybody
you've been very helpful for answering my last questions, but this one has popped up and i dont understand very much of it ( i found the code somewhere in the forums and thought it would be useful )
=INDEX(Results!A:A,MATCH(9.99999999999999E+307,Results!A:A),1)*1000
this will return the value of the cell in the last row of the Column "A"
is it possible to include some type of modification to this code to make it find the last value, but search no further than say 500 rows down the column ?
and also how to make it return the last cell's value between 500-1000
it'd be very handy to have for multiple values on the same column, as i have large amounts of data divided into sections, and would like a report to include the last entry for each section on a page
thanks everybody