Hi there
I have a huge number of rows with sales data. I want to use the slope formula to determine the trend. However the sales data is full of gaps like this example.
<tbody>
</tbody>
Since the data doesn't start and end at the same columns all the time, I was wondering if anybody knows a way to solve this (for example in row 1 I want to use everything, in row 3 I only want to use 8-7-3-8-9, in row 5 I want to use 3-1-6-9-2)
Thanks!
I have a huge number of rows with sales data. I want to use the slope formula to determine the trend. However the sales data is full of gaps like this example.
3 | 4 | 5 | 8 | 0 | 2 | 8 |
N/A | 5 | 8 | 1 | 9 | 7 | 1 |
5 | N/A | 8 | 7 | 3 | 8 | 9 |
3 | 8 | 9 | 5 | 3 | 1 | N/A |
N/A | 3 | 1 | 6 | 9 | 2 | N/A |
<tbody>
</tbody>
Since the data doesn't start and end at the same columns all the time, I was wondering if anybody knows a way to solve this (for example in row 1 I want to use everything, in row 3 I only want to use 8-7-3-8-9, in row 5 I want to use 3-1-6-9-2)
Thanks!
Last edited: