Showing Last Value in a column
 

Hi - is there any way that if I have a column with numbers in each cell, to
be able to put in a formula (without using a vlookup) that will give me the
last value in that column please?
(e.g the column numbers range from 1 to 20 and I want a cell to bring
through the value of 20)

thanks in advance

Showing Last Value in a column
 

Hi,

This does it for column B

=INDEX(B:B,MATCH(6.022*10^23,B:B))

Mike

"Cadders" wrote:

Hi - is there any way that if I have a column with numbers in each cell, to
be able to put in a formula (without using a vlookup) that will give me the
last value in that column please?
(e.g the column numbers range from 1 to 20 and I want a cell to bring
through the value of 20)

thanks in advance

Showing Last Value in a column
 

You are a star Mike - thanks for your help

"Mike H" wrote:

Hi,

This does it for column B

=INDEX(B:B,MATCH(6.022*10^23,B:B))

Mike

"Cadders" wrote:

Hi - is there any way that if I have a column with numbers in each cell, to
be able to put in a formula (without using a vlookup) that will give me the
last value in that column please?
(e.g the column numbers range from 1 to 20 and I want a cell to bring
through the value of 20)

thanks in advance

Showing Last Value in a column
 

If the numbers are in ascending order then the last value in the range
should be the max value:

=MAX(A1:A100)

If the numbers are in random order:

=LOOKUP(1E100,A1:A100)

--
Biff
Microsoft Excel MVP


"Cadders" wrote in message
...
Hi - is there any way that if I have a column with numbers in each cell,
to
be able to put in a formula (without using a vlookup) that will give me
the
last value in that column please?
(e.g the column numbers range from 1 to 20 and I want a cell to bring
through the value of 20)

thanks in advance