Results 1 to 3 of 3

Thread: Comparing the Same Month Sales between Two Different Years.

  1. #1

    Comparing the Same Month Sales between Two Different Years.

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

    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,
    Attached Files Attached Files

  2. #2
    I recommend you scrap every little bit of your sales report
    and start from scratch with Tables and PivotTables and Slicers.
    No formulas, no code needed.

  3. #3
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    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?

Posting Permissions

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