last non-empty cells

[krayzie killa]

is there a formula for displaying the last non-empty cell or the last used
cell in a column or row? if there is kindly notify me at
(e-mail address removed). i needed it badly.

 

[Don Guillett]

one way is to look for a number or letter larger than possible
=match(99999999,a:a)
or
=match("zzzzzzzzz",a:a)

 

[Ron Rosenfeld]

On Sat, 15 Mar 2008 05:53:00 -0700, krayzie killa <krayzie

is there a formula for displaying the last non-empty cell or the last used
cell in a column or row? if there is kindly notify me at
(e-mail address removed). i needed it badly.

Last entry in column A:

=LOOKUP(2,1/(LEN(A:A)>0),A:A)

Last entry in Row 1:

=LOOKUP(2,1/(LEN(1:1)>0),1:1)

--ron

 

[Teethless mama]

Your formula returns #NUM! error prior to XL-2007

Last entry in column A:
=LOOKUP(2,1/(LEN(A:A)>0),A:A)

should be:
=LOOKUP(2,1/(LEN(A1:A65535)>0),A:A)

 

[Ron Rosenfeld]

Your formula returns #NUM! error prior to XL-2007

should be:
=LOOKUP(2,1/(LEN(A1:A65535)>0),A:A)

I just switched to 2007. I guess "compatibility mode" in 2007 doesn't take
that into account. Thanks for the correction.
--ron