morning,
I have 3 rows of random data showing a number of product orders across 12 months. Each row shows a product line. However not all sales lines start in month 1. Therefore I need to shift the start month right by ’x’ number of months. X is again random.
product 1 starts in month 1
product 2 in month 4
and product 3 in month 6.
for this example every grows by 1 each month (1,2,3,4,5 etc...). However in my spreadsheet it is a random percentage.
any help much appreciated
I have 3 rows of random data showing a number of product orders across 12 months. Each row shows a product line. However not all sales lines start in month 1. Therefore I need to shift the start month right by ’x’ number of months. X is again random.
product 1 starts in month 1
product 2 in month 4
and product 3 in month 6.
for this example every grows by 1 each month (1,2,3,4,5 etc...). However in my spreadsheet it is a random percentage.
any help much appreciated