+ Reply to Thread
Results 1 to 4 of 4

Align Sales from Launch Months

  1. #1
    Registered User
    Join Date
    01-11-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    3

    Question Align Sales from Launch Months

    I have thousands of products launched at different time points. Want to align the sales from the month of their launch. Month Align.xlsx Have attached file here as an example. Need a formula to this in Excel 2010

    thanks
    Attached Images Attached Images

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,723

    Re: Align Sales from Launch Months

    So, the upper table is what you have, and you want to convert into the table below?

    Pete

  3. #3
    Registered User
    Join Date
    01-11-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    3

    Re: Align Sales from Launch Months

    Hi Pete, thanks for your response. You are right. Upper table is my raw data. Lower table is how i want my outputs

    raiyanimv

  4. #4
    Registered User
    Join Date
    01-11-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    3

    Re: Align Sales from Launch Months

    Hi Pete, thanks for your response. You are right. Upper table is my raw data. Lower table is how i want my outputs

    raiyanimv

+ 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] Formula to extract months with highest Sales
    By pwnyadav007 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-13-2016, 01:10 PM
  2. Changing launch month but keeping starting sales value as same
    By james444 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-22-2016, 10:38 AM
  3. Top 10 Months by Sales Person in PivotTable
    By Rossy87 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-20-2013, 01:28 PM
  4. Sales forecasting across months
    By tfboland in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-18-2013, 10:35 AM
  5. sales average across all employees and all months and more
    By amirs318 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-24-2008, 06:30 PM
  6. [SOLVED] calculation sales of particular month among months of sale
    By Rao Ratan Singh in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-03-2006, 08:50 AM
  7. Macro launch - Button vs Manual launch , has different results.
    By Wayne in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2005, 08:06 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