get the data from the last row with data I am trying to get the da

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

-- 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
 
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?
 
Thanks for your help--I will try it asap--also I am new to the group and did
not read the choices throughly but I am glad you pointed it out--thanks again.

Kyler Lunman
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
VBA - retrieve data on last create named range from previous inserted named range 0
Macro to automatically select the last row of data after refresh 10
Get data reference to last row 5
Add Sum to the columns at the last row 5
Deleting the last row 3
Loop from left to the right 5
Copy and Paste LAST ROW of data 18

Back
Top