=MAX(ROW(A1:A1500)*(A1:A1500<>""))

entered as an array formula with <Ctrl> <Shift> <Enter>.

--

Vasant


"PosseJohn" <PosseJohn@discussions.microsoft.com> wrote in message
news:B03D390D-7CBE-43B4-805F-946503C313AA@microsoft.com...
> 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?