| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last row w/ non-null result of formula
I know how to use the End(xlUp) property to find the last row with data.
However, I have a sheet full of formulas which return either a value or NULL. Using End(xlUp) returns the last row containing anything, including formulas. How do I find the last row that contains NON-NULL VALUES resulting from these formulas. For example, I have 20 rows with formulas in them. Only the first "x" rows have non-null values resulting from these formulas. The remaining (20 - "x") rows contain the formulas but they return null values. How do I determine the value of "x"? -- Will |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sub to copy only result lines within formula range, omit null string lines | Excel Programming | |||
| How do I get Null as a result of an if? | Excel Discussion (Misc queries) | |||
| check if the result of a formula is null | Excel Programming | |||
| How do I set a result of an "if" function to NULL; not 0 or ""? | Excel Worksheet Functions | |||
| if A1=Null and B1=A1 why is result in B1=0 ?? | Excel Discussion (Misc queries) | |||
Threaded Mode
