| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| skip cells with zero values in chart (cells not empty) | Charts and Charting in Excel | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| When I SUM cells & 1 is empty I need the result to be empty not 0 | Excel Discussion (Misc queries) | |||
| How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
| how do populate empty cells with the contents of populated cells . | Excel Discussion (Misc queries) | |||
Hybrid Mode
