ExcelBanter - =TREND

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - =TREND (https://www.excelbanter.com/excel-discussion-misc-queries/219069-%3Dtrend.html)

Builder

=TREND

Is there a way to get the =TREND formula to ignore blank rows?

Dave Curtis[_2_]

=TREND

Hi,

Yes, use =FORECAST instead.

I don't know why FORECAST allows blanks but TREND doesn't.

Dave

"Builder" wrote:

Is there a way to get the =TREND formula to ignore blank rows?

Builder

=TREND

Thank you very much for the help.

"Dave Curtis" wrote:

Hi,

Yes, use =FORECAST instead.

I don't know why FORECAST allows blanks but TREND doesn't.

Dave

"Builder" wrote:

Is there a way to get the =TREND formula to ignore blank rows?

All times are GMT +1. The time now is 09:08 AM.