Results 1 to 3 of 3

Thread: Compare value of current month with previous mont

  1. #1

    Compare value of current month with previous mont



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    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,

  3. #3
    It works perfectly...Thank you very much

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •