Return Value of last cell in column with a value in Excel?

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

Guest

Is there an Excel funtion that calls the last value in a column? For example
I have a column that will be continuosly added to (through barcode scan) and
I need the last value in that column to show up in a specific cell. It sounds
so simple. there has to be a built in function, is there not? And if not can
someone help me with the code? (I don't know VBA too well, but understand the
logic)

Thanks.
 
As long as there are no empty/blank cells within the range:

=INDEX(A:A,COUNTA(A:A))
 
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

Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
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
help with formula for last input in column 6
Return column header based on last value in row 3
Last value in column before blank 10
Excel VBA 1
Extract first value and last value from a table 1
How do I add up the last 12 cells (containing values) in a column. 4

Back
Top