Help with TREND function

S

systemx

Hi all,

I was hoping someone could offer some help or advice with some data
analysis I am conducting.

I have a fixed range of data - let's say B1:C5. The range contains the
known X and Y values for a trend. Range A1:A5 contains dates.

Currently, some of the cells contain 0, either because data does not
exist for that day (historically) - or because it is not yet available
(yet to occur).

eg.

01/03/05 4134 27
04/03/05 0 0
18/07/08 5122 33

I want to calculate trends on this data - excluding zero values or
blank cells from the range.

Bearing in mind, as more values become available, the trend value will
change - which is why I need it to calculate the trend based on cells
in the range that contain a value.

Can anyone offer any advice or assistance as to how this can be done?

Cheers

Rob :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top