Percentage increase table

[Lara_1234]

All

I have % increase against some months, i need the formula to match answer as shown .

Question

Month

Jan-23​

12%​

Feb-23​

8%​

Mar-23​

0%​

Apr-23​

10%​

Jan-23​

Feb-23​

Mar-23​

Apr-23​

May-23​

Jun-23​

Jul-23​

Aug-23​

Sep-23​

Oct-23​

Nov-23​

Dec-23​

Answer

12%​

20%​

20%​

30%​

30%​

30%​

30%​

30%​

30%​

30%​

30%​

30%​

 

[Lara_1234]

Hi

I need a excel formula in each month to arrive the answer

 

[rahulshewale1]

Hi @Lara_1234 ,


PFA File. Please check

Regards,
Rahul Shewale

 

[Lara_1234]

hi
this is good, but i was not looking for this

 

[bosco_yip]

Or, try this formula solution for all Excel 2010 versions and above.

In C4, formula copied across right:

=SUM(B4,IFERROR(LOOKUP(9^9,0+LEFT(INDEX($C1:$Z1,MATCH(C3,$C1:$Z1,0)+1),{1,2,3,4})),0))

 

[Lara_1234]

thanks

 

[Lara_1234]

Came up with the attached.

 

[Peter Bartholomew]

Because I use 365, I decided to try a different approach.

= WRAPCOLS(input,2)

looked as if I were halfway there, but it turned out that the apparent percentages were text and not numeric

A quick Lambda function to convert the text to percentages

Percentλ
= LAMBDA(x, IFERROR(TEXTBEFORE(x, "%") / 100, 0))
Addλ
= LAMBDA(x,y, x+y)

and another to add two numbers
gave the final form

= LET(
      table,  WRAPCOLS(input,2),
      dates,  TAKE(table,1),
      pcText, DROP(table,1),
      pc,     Percentλ(pcText),
      acc,    SCAN(0,pc,Addλ),
      VSTACK(dates, acc)
  )

giving

Whether anyone would recognise this as a regular Excel solution is another matter!

 

[Lara_1234]

This is interesting

 

[Peter Bartholomew]

This is the copy of Bosco's file with the additional rows showing the formula.