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

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.

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

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


--
Regards,

Peo Sjoblom




"mike" wrote in message
...
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.

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

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

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

--
Biff
Microsoft Excel MVP


"mike" wrote in message
...
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.

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

This works, thanks Peo.


"Peo Sjoblom" wrote:


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


--
Regards,

Peo Sjoblom




"mike" wrote in message
...
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.