Results 1 to 7 of 7

Comparing sales per hour this year, with last years.

Threaded View

  1. #1
    Registered User
    Join Date
    01-24-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    5

    Lightbulb Comparing sales per hour this year, with last years.

    Hey guys,

    Let me explain,

    Work has given me a hourly sales data for the last 2 weeks, and Last years hourly data for the equivalent 2 weeks.

    The question is compare the average of the last 2 weeks against the average of the equivalent 2 weeks last year and evaluate if the trading performance is majorly different.

    I have to copy the answer to use it with other sites aswell so nothing too long.

    This is such an easy task, yet I cant seem to get my head around it. What formulas to use? Should I use percentages or leave it? Charts graphs are all welcome too. Please help! I want to impress!

    Kennith
    Attached Files Attached Files
    Last edited by iExcelDummy; 01-24-2014 at 02:47 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to account for head to head matchup in Excel with other tie breakers
    By Biogeek1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-26-2013, 05:18 PM
  2. Over my head, but probably simple...*sigh*
    By nojrellum in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2010, 08:31 PM
  3. Simple If formula but can't get my head around it!
    By Cheryl in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-19-2006, 09:40 AM
  4. A simple question requiring a simple answer
    By Pedros in forum Excel General
    Replies: 3
    Last Post: 07-18-2006, 06:45 AM

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