Trend in Excel

[Ian]

Is it possible to use the TREND function (or something similar) on a set of ratings where one or more of the ratings in the range is excluded ? eg, you have a set of ratings but want to exclude the ones on the "wrong" going.

[osknows]

Hi Ian,

It's possible to use TREND to complete missing values but there are 2 issues I can think of

1. Organising the data. I don't think the TREND function likes gaps in the known data. The data needs to be sorted into contiguous range of known data and unknown data.

2. TREND will produce a value based on the known data. Whether that value has any significance is unknown using TREND alone.

[Ian]

Thanks os. It was point 1 that I wanted to see if I could get around easily ie. using trend on non-contiguous data.