+ Reply to Thread
Results 1 to 6 of 6

Comparing the Same Month Sales between Two Different Years

  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    18

    Comparing the Same Month Sales between Two Different Years

    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
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: Comparing the Same Month Sales between Two Different Years

    Is this what you wanted?
    Attached Files Attached Files
    1. Include a sample workbook with an example of the result you want
    2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
    3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.

  3. #3
    Registered User
    Join Date
    06-04-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Comparing the Same Month Sales between Two Different Years

    Yes the function is operating how i want it. I just need it to calculate for each individual tenant as opposed to the whole spreadsheet. The tenant names are all deleted but their unit numbers still are there. Is there a way you type in the tenant name and it will automatically reference it instead of the whole spreadsheet. So you would type in the month, the years, the tenant name and then it would spit out the comparison similar to what is id doing currently?

  4. #4
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: Comparing the Same Month Sales between Two Different Years

    I'm modifying your Summary sheet to make it usable for this function. I would use your data sheet, but it has a bunch of merged cells, so it's actually less usable than the summary.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-04-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Comparing the Same Month Sales between Two Different Years

    K64, I think this will work fine, even if it isnt referencing the data sheet. For future reference i will avoid merging cells.

    Thank you so much, this has saved me a ton of time!

  6. #6
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: Comparing the Same Month Sales between Two Different Years

    You're welcome. Glad I could help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Comparing sales per hour this year, with last years.
    By iExcelDummy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-24-2014, 05:11 PM
  2. Replies: 2
    Last Post: 10-16-2012, 11:40 AM
  3. Replies: 4
    Last Post: 08-28-2012, 01:31 AM
  4. Replies: 3
    Last Post: 02-10-2010, 09:49 AM
  5. track sales history by month for several years
    By Kyle in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 07-07-2005, 02:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1