Is there a formula to transfer the last value in a column

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

Guest

I have all $ amounts in the column. I need a formula that picks up the last
value in the column and transfers it to another cell in another worksheet. Is
there a formula to do that? Thanks......Need this As Soon As Possible!!!!
 
Column A

=LOOKUP(2,1/(A1:A65535<>""),A1:A65535)



--


Regards,


Peo Sjoblom
 
Peo,
permit me to add a bit of spice!
say Sheet1 is where column A with values exist.
say sheet 2 - where u want to copy/link the value

=LOOKUP(2,1/(Sheet1!A1:A65535<>""),Sheet1!A1:A65535)

yet to litteraly *transfer* the last value, i suggest to cut and paste the
desired last value from sheet1 to sheet2...
 
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

Excel VBA 1
Hide columns based on row values 2
help with formula for last input in column 6
Last value in column 1
Formula to find last different value in a column? 5
Locking a cell reference in a formula 1
Excel Subtracting multiple columns from another column 3
FORMULA HELP ! ! 1

Back
Top