On Jun 19, 3:16 pm, Tom Ogilvy
wrote:
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?- Hide quoted text -

- Show quoted text -

It's a problem when you have a data dump in columns (Linest at the
bottom cell) where there is varying rows between columns- trying to
automate the beta calculation whenever information is updated.