Auto-copy the last entry in a column to a new cell

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

Guest

I want to auto-copy the last calculated result in a column, to a specific
cell. The column can be any length but not all cells in the column will
contain data, I only want the last result.
 
Hi!
I want to auto-copy the last calculated result in a column
Click to expand...

Does "calculated" mean that it's a numeric value?

With the column in question being column A, try this:

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

Biff
 
=OFFSET(A1,MAX(IF(A1:A1000<>"",ROW(A1:A1000)))-1,)
array entered (Ctrl+Shift+Enter) in the cell you want.

Modify A1000 to suit your needs or A.

HTH
GerryK
 
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
Last Modified By in a cell by user 3
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Excel VBA 1
How to reference last non-blank cell value from a column cells? 2
First, Last occurance of date in column 5
Copy corresponding cell in Column B if cell in A contains certain text? 1
Hide columns based on row values 2

Back
Top