Calculating Year over Year and Month over Month in sales

jaayttr26

New Member
Joined
Mar 23, 2020
Messages
1
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Which months have the greatest improve YoY in sales? Which months in 2019 have the greatest improvement MoM in sales?

If the Formula is : YoY: (Present-Past)/ Past,

For the Yoy would it be: January, February, and April?

For the MoM would it be: September, July, and November?

Since those months have the 3 highest values
20192018
MonthLeadsSalesLeadsSales
January 70,050
8525​
65,899
7132​
February 68,926
9545​
68,850
8152​
March 91,794
10685​
81,248
9292​
April 87,325
9656​
78,513
8263​
May 106,431
11542​
78,075
10149​
June 107,551
12454​
72,645
11061​
July 121,583
15874​
73,766
14481​
August 135,986
19065​
82,888
17672​
September 108,915
78495​
67,827
77102​
October 120,188
14525​
62,042
13132​
November 131,147
18025​
69,287
16632​
December 87,452
9854​
98,786
8461​
 
Last edited by a moderator:

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Forum statistics

Threads
1,213,546
Messages
6,114,253
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top