FORECAST Based on Column Value.

[acprkit]

Hi All,

I have a large number of products that I would like to use the forecast formula to predict sales for based on Save %. Preferably, I would like the function to evaluate sales and save based on the product # in the first column (like a FORECASTIF formula), since there are hundreds of products with a varying number of records.

I understand that linest could also be appropriate for this, but I still can't figure out how to make the formula automatically pick the range.

Product #	Sales	Save %
1	50	5
1	100	40
1	75	30
2	20	35
2	10	10
3	15	20
3	250	0
3	300	15

<tbody>
</tbody>

Thanks for any help with this!