+ Reply to Thread
Results 1 to 2 of 2

Dynamic YDT calculation for different divisions

  1. #1
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    Dynamic YDT calculation for different divisions

    Dear experts,


    I need formula for dynamic ytd calculation for the scenario mentioned below.

    YTD YTD YTD
    Month Apr-13 Apr-13 Apr-13 May-13 May-13 May-13 June-13 June-13 June-13 May-13 May-13 May-13
    Product type x y z x y z x y z x y z
    sales executive
    a 5 10 15 20 25 30 35 40 45 ? ? ?
    b 4 8 12 5 7 11 12 69 79 ? ? ?

    Thanks in advance.

  2. #2
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Dynamic YDT calculation for different divisions

    Please post a sample workbook with the result you expect to get. Just by looking at the above post, we could not derive any output.

    Sarang

  3. #3
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Dynamic YDT calculation for different divisions

    Dear Sarang,
    I have posted the problem with sample workbook. The link for the same is provided below.

    Please go through the same and help me. Thanks!

    http://www.excelforum.com/excel-form...-required.html

+ 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. Calculate POINTS and DIVISIONS
    By nkhondeya@gmail.com in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 09-24-2013, 03:39 PM
  2. [SOLVED] Random Sports Schedule Creator with 2 Divisions
    By Phily915 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-15-2013, 09:23 PM
  3. [SOLVED] Formula for irregular row divisions
    By zhl in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 04-08-2013, 07:00 PM
  4. array formula and divisions
    By matt_pl in forum Excel General
    Replies: 2
    Last Post: 10-10-2006, 04:34 AM
  5. Statistics (average of multiple divisions)
    By markx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-21-2005, 10:06 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