Copy the last cell in an Excel column to another cell

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

Guest

I am a novice excel user. I have a spread sheet that continually changes,
rows and columns add or subtract up to a total. The total column contiunues
to grow in length as new entries are made. Can this last cell with an entry
be copied to another cell, for example in a header back at the top of the
spread sheet? I have tried to find a function to no avail...MAX wont work
becasue the number can get smaller.

Thanks in advance.
 
Assuming that Column C contains the 'Total', try...

=LOOKUP(9.99999999999999E+307,C:C)

Hope this helps!
 
For example to get the last cell in column A use:

=LOOKUP(2,1/(A2:A65356>0),A2:A65356)

Started with A2 because A1 had a label
 

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

Help needed 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Last text entry in a column 4
add or subtract every 5th column 2
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
Excel Subtracting multiple columns from another column 3
Getting Info from Last cell used 1
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2

Back
Top