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.
<tbody>
</tbody>
Thanks for any help with this!
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!