Compare value of current month with previous mont

ntebaleng

New member
Joined
Jul 14, 2014
Messages
6
Reaction score
0
Points
0
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

JanFebMarchAprilMayJuneJulyAugSeptOctNovDecTrend
Product1546458 Increasing
Product2534964 Decreasing
Product3357488 Constant
 

bgoree09

New member
Joined
Aug 20, 2013
Messages
179
Reaction score
0
Points
0
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,
 
Top