Quote:
I have a column of numbers that fills in when certain other conditions are met.


So the sheet is logging values whenever some condition rings true.

How about this
=INDIRECT(("R"&COUNTA(A:A)&"C"&COLUMN(A1)),FALSE)

It works but, Column A has to be devoted to the log, the log has to start in the first row, and null values in the column can result in the address being short of the log bottom.

PS: I dosen't matter what is in the log it could even be ="" or ' , as long as the log entries don't leave empty cells. Of course, if you use a variant of this to fill the log there will never be a null cell because it will always point to the cell after the last.


Edited by gbeer (13/08/2004 03:22)
_________________________
Glenn