last non-empty cells
 

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
. i needed it badly.

last non-empty cells
 

one way is to look for a number or letter larger than possible
=match(99999999,a:a)
or
=match("zzzzzzzzz",a:a)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"krayzie killa" <krayzie wrote in message
...
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
. i needed it badly.

last non-empty cells
 

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

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
. 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

last non-empty cells
 

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" wrote:

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

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
. 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

last non-empty cells
 

On Sat, 15 Mar 2008 08:29:02 -0700, Teethless mama
wrote:

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)

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