Shows the lasl number entered

[kuzna26]

Hi guys,


Please I have spread sheet, and in column B I will entering number and I would like to
have the last entered number in cell C4


Any help


thank you,

[GaryBarlow]

If your numbers in column B always increase then you could just use:

=MAX(B5:B64)

This will return the largest number in the range.

If they can also decrease then you could use something like:

=INDIRECT("B"&COUNTA(B5:B64)+4)

The +4 at the end of the formula is because the data starts on row 4.

HTH

[Glenn Kennedy]

Do you mean the number that occurss furthest down the column?

If so - this will do the trick:

=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))

If not, please explain exactly what you want.