Formular to read the last entry in a column
=LOOKUP(99^99,H:H)
"Dhew" wrote:
I am trying to calculate a "latest result" in which I need to read the last
(Not greatest or smallest) figure in a column:
e.g. column H has five figures in it, 100, 75, 70, 50, 65. I want a cell
that will show me the answer or 65, and if another figure is added
afterwards, for my latest result cell to show whatever is in this figure.
How can I do this???
|