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

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.
 
T

T. Valko

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

=INDEX(A:A,COUNTA(A:A))
 

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
Return the value from one range that does not exist in another 0
Return column header based on last value in row 3
Last value in column before blank 10
help with formula for last input in column 6
Excel VBA 1
return the Cell address of a value 3
LOOKUP value in a table and return value in first column of same r 2

Top