How about:
=LOOKUP(2,1/(LEN(J45:J85)0),J45:J85)
or
=IF(COUNTA(J45:J85)=0,"None!",LOOKUP(2,1/(LEN(J45:J85)0),J45:J85))

Since you wanted a formula solution, why not post in .worksheet.functions?

Fred Tuck wrote:

-- I am trying to get the data from the last cell with data in the middle of
a column:
such as column J2:J255 and i need to examine J45:J85 and find the data in
the last cell, from the bottom of that particular subset and it may vary from
day to day IE today it acutally maybe J85, tommorrow it may be J79. I need a
formula as opposed to a macro. Any ideas?
Fred Tuck

--

Dave Peterson