Linest works on XY pairs. It isn't designed to work with missing data points.

In your example why wouldn't you use C3:C6, D3:D6

--
Regards,
Tom Ogilvy


" wrote:

The Excel function Linest does not return a value if your independant
and dependant variable count :i.e. Linest(C3:C18,D3:D6) do not match.
Is there a way to code this in VBA?