Finding the Value in a Last-Filled Column-Cell

[GBL]

Hi:
I have formatted a column of currency values (D1100). Each day a
value is sequentially calculated in these cells starting with D1 then D2
then D3, etc. - so all the values are contiguous (except the first and
last). For example: say the cells in the range of (D114) have been
calculated (no blank cells). I need a function/formula to read the last
calculated cell (in this case the D14 cell) in the daily growing column.

Any help would be appreciated.

Thanks in Advance

 

[Don Guillett]

try
=INDEX(d:d,MATCH(9.99999999999999E+307,d:d))

 

[Gord Dibben]

GBL

=MATCH(9.99999999999999E+307,A:A) row number of last numeric cell in column

=ADDRESS(MATCH(9.99999999999999E+307,A:A),1) address of last numeric cell in
column

=LOOKUP(9.99999999999999E+307,A:A) return the last numeric value in A.

Gord Dibben XL2002