Hi,
I want to compare the values of the cauurent month with the previous data month and display of the values "increased,remain constant,or decrease"
For instance,excel must cpare tha vales for May and June then on the TREND col,it must state the condition.Please note that when the user enters data for July,it should compare july and june etc
I want to compare the values of the cauurent month with the previous data month and display of the values "increased,remain constant,or decrease"
For instance,excel must cpare tha vales for May and June then on the TREND col,it must state the condition.Please note that when the user enters data for July,it should compare july and june etc
Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec | Trend | |
Product1 | 5 | 4 | 6 | 4 | 5 | 8 | Increasing | ||||||
Product2 | 5 | 3 | 4 | 9 | 6 | 4 | Decreasing | ||||||
Product3 | 3 | 5 | 7 | 4 | 8 | 8 | Constant |