Percent Change

[bumfart66]

Hi

I want to insert a formula in E2 that compares the month year following, for example Jan 23 with Jan 24

Sales Month	Sales Total	Contract Length Totals	Average Contract Length	Percent Difference
Jan-2023	146	3975	27
Feb-2023	223	7096	32
Mar-2023	307	8787	29
Apr-2023	193	6882	36
May-2023	273	7990	29
Jun-2023	303	9944	33
Jul-2023	393	10181	26
Aug-2023	243	9360	39
Sep-2023	310	10098	33
Oct-2023	299	8603	29
Nov-2023	264	7767	29
Dec-2023	239	5303	22
Jan-2024	239	6775	28
Feb-2024	290	7858	27
Mar-2024	330	9018	27
Apr-2024	397	10372	26
May-2024	366	11357	31
Jun-2024	301	8194	27
Jul-2024	302	7722	26
Aug-2024	115	3363	29

 

[Peter_SSs]

Is it something like this that you are after?

24 08 19.xlsm
	A	B	C	D	E
1	Sales Month	Sales Total	Contract Length Totals	Average Contract Length	Percent Difference
2	Jan-23	146	3975	27	63.70%
3	Feb-23	223	7096	32	30.04%
4	Mar-23	307	8787	29	7.49%
5	Apr-23	193	6882	36	105.70%
6	May-23	273	7990	29	34.07%
7	Jun-23	303	9944	33	-0.66%
8	Jul-23	393	10181	26	-23.16%
9	Aug-23	243	9360	39
10	Sep-23	310	10098	33
11	Oct-23	299	8603	29
12	Nov-23	264	7767	29
13	Dec-23	239	5303	22
14	Jan-24	239	6775	28
15	Feb-24	290	7858	27
16	Mar-24	330	9018	27
17	Apr-24	397	10372	26
18	May-24	366	11357	31
19	Jun-24	301	8194	27
20	Jul-24	302	7722	26
Compare

Cell Formulas
Range	Formula
E2:E20	E2	=IF(B14="","",(B14-B2)/B2)

 

[bumfart66]

Is it something like this that you are after?

24 08 19.xlsm
	A	B	C	D	E
1	Sales Month	Sales Total	Contract Length Totals	Average Contract Length	Percent Difference
2	Jan-23	146	3975	27	63.70%
3	Feb-23	223	7096	32	30.04%
4	Mar-23	307	8787	29	7.49%
5	Apr-23	193	6882	36	105.70%
6	May-23	273	7990	29	34.07%
7	Jun-23	303	9944	33	-0.66%
8	Jul-23	393	10181	26	-23.16%
9	Aug-23	243	9360	39
10	Sep-23	310	10098	33
11	Oct-23	299	8603	29
12	Nov-23	264	7767	29
13	Dec-23	239	5303	22
14	Jan-24	239	6775	28
15	Feb-24	290	7858	27
16	Mar-24	330	9018	27
17	Apr-24	397	10372	26
18	May-24	366	11357	31
19	Jun-24	301	8194	27
20	Jul-24	302	7722	26
Compare

Cell Formulas
Range	Formula
E2:E20	E2	=IF(B14="","",(B14-B2)/B2)

It was the average contract length i wanted to compare but your solution works , thanks

 

[Peter_SSs]

It was the average contract length i wanted to compare ..

I had a 1 in 3 chance of guessing which column since you didn't say, or give sample results.

.. but your solution works , thanks

You're welcome. Thanks for letting us know.

 

[kvsrinivasamurthy]

In E2 . Format the range for %

=IFERROR((INDEX($B3:$B$21,MATCH(DATE(YEAR(A2:A21)+1,MONTH(A2:A21),1),$A3:$A$21,0))-(B2:B21))/(B2:B21),"")