Finding the Value in a Last-Filled Column-Cell

Finding the Value in a Last-Filled Column-Cell

Post by GBL » Wed, 05 Nov 2003 23:11:42


Hi:
I have formatted a column of currency values (D1:D100). 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 (D1:D14) 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

--
Best Regards,
GBL
 
 
 

Finding the Value in a Last-Filled Column-Cell

Post by Don Guille » Thu, 06 Nov 2003 00:03:03

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

 
 
 

Finding the Value in a Last-Filled Column-Cell

Post by Gord » Thu, 06 Nov 2003 02:30:15

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