Comparing the Same Month Sales between Two Different Years.

stacesil

New member
Joined
Jun 28, 2013
Messages
2
Reaction score
0
Points
0
I am trying to create a function where the user can type in a single month, and 2 different years, and it will calculate/compare that single month from the 2 different years entered.

For Example: I type in January, and I type in 2014 and 2013. The excel formula will spit out whether January 2014 is over/under January 2013.

See attached for my sales report. You can see where I left some space for the requested function.

Please Please Please can you assist, as it is the last change I have to make to the sales report.

Thank you,
 

Attachments

  • Sales Report Excel Guru.xlsx
    195.7 KB · Views: 287
I agree, pivots would be better, but with your data, you might struggle, you would need to unpivot it.

Where would this summary go, and what would it look like?
 
Back
Top