Showing Last Value in a column

[Cadders]

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

 

[Mike H]

Hi,

This does it for column B

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

Mike

 

[Cadders]

You are a star Mike - thanks for your help

Hi,

This does it for column B

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

Mike

 

[T. Valko]

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)