Hi,

Your formula is returning the row number so putting -1 on the end will
return the row number of the second to last row. You could use this instead
which does the same

=SUMPRODUCT(MAX((ROW(A1:A1000))*(A1:A1000<"")))-1

Mike

"jfp" wrote:

=IF(ISERROR(MATCH(9.999999E+306,A:A)),MATCH("*",A: A,-1),
IF(ISERROR(MATCH("*",A:A,-1)),MATCH(9.999999E+306,A:A),
MAX(MATCH(9.999999E+306,A:A),MATCH("*",A:A,-1))))

I have the above function which allows me to select the final data I have
inputted. What do I need to add in order to get the last but one piece of
data? Is this possible?

I create tables which have todays price, last weeks price and the price from
the corresponding week last year too (so having the option for 52 cells above
the last one would also be useful). These prices are all listed in a table
which I then need to summarise - hence the request.

Many thanks

James