+ Reply to Thread
Results 1 to 3 of 3

Use excel to show long term sales increase

  1. #1
    Registered User
    Join Date
    05-21-2015
    Location
    England
    MS-Off Ver
    2013
    Posts
    25

    Exclamation Use excel to show long term sales increase

    I have a spreadsheet which is around 16,000 rows long which helps me to decide what items i need to re order. I want to be able to identify products which have increased by over 25% in volume so we can negotiate prices with suppliers. I use a simple formula to compare sales average from Jun-Mar with sales from May-Feb which identifies a sudden spike, but i also want to see if there is a gradual increase. Any ideas? Cumulative % maybe? Im lost, the zeros dont help when i try to calculate a cumulative % changes......



    4 month average Jun May Apr Mar Feb Jan Dec Nov Oct Sep Aug Jul
    7 20 0 8 0 2 1 0 0 0 8 1 0
    2 5 0 0 4 0 0 0 0 0 4 1 0
    16 0 0 6 9 50 0 12 5 0 8 0 0
    1 1 0 1 0 1 4 4 0 0 4 0 0
    1 0 0 0 2 0 0 0 0 0 2 0 0
    0 0 0 0 0 0 0 0 0 0 0 0 0

  2. #2
    Registered User
    Join Date
    08-13-2008
    Location
    California
    Posts
    17

    Re: Use excel to show long term sales increase

    Attach your worksheet to your post

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Use excel to show long term sales increase

    Welcome to the forum:
    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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] Confused on which formula to use for long term budgeting
    By hotzpacho in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-15-2015, 06:47 AM
  2. Calculating short term and long term moving average in VBA
    By ixthus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-10-2013, 02:40 AM
  3. Long term lurker!!
    By Craig.Selby in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 07-10-2012, 09:37 PM
  4. Replies: 2
    Last Post: 07-21-2010, 12:54 PM
  5. excel sales increase
    By shawnjohnson in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 11-16-2006, 09:21 AM

Tags for this Thread

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