Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an array formula that extends 1500 rows. The formula in the cells
return data from another source. I need to graph this data, but the graph (as expected) plots all the cells with no actual value. How do I detect what row the last real value is contained in? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
Array Formulas | Excel Worksheet Functions | |||
Function CELL in array formulas | Excel Discussion (Misc queries) |