Compare value of current month with previous mont

[ntebaleng]

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

	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

[bgoree09]

Good morning,

Assuming the table starts in A1 (Jan in B1 and Product1 in A2), use in N2:

=IF(INDEX(B2:M2,1,COUNT(B2:M2))-INDEX(B2:M2,1,COUNT(B2:M2)-1)>0,"Increasing",IF(INDEX(B2:M2,1,COUNT(B2:M2))-INDEX(B2:M2,1,COUNT(B2:M2)-1)<0,"Decreasing","Constant"))

and drag down.

This could probably be condensed, but it works.

Best of luck,

[ntebaleng]

It works perfectly...Thank you very much