+ Reply to Thread
Results 1 to 3 of 3

How to generate table from cumulative table?

  1. #1
    Registered User
    Join Date
    04-09-2014
    Location
    Melaka, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    2

    How to generate table from cumulative table?

    Hye all, Im newbie here.
    Is anyone can advice me how to generate full table refer to cumulative table?
    Here are the example:

    From, To, per 1, cumulative
    -200, 0 , 0.285 , 411
    0 , 10 , 17.47 , 586
    10 , 20 , 23.35 , 820
    20 , 23 , 28.16667 , 904
    23 , 50 , 28.30236 , 1668
    50 , 150 , 28.28914 , 4497
    150 , 190 , 28.23915 , 5627

    convert to full table as example :

    0, 411
    1, 428.47
    2, 445.94
    3, 463.41
    4, 480.88
    5, 498.35
    6, 515.82
    7, 533.29
    8, 550.76
    9, 568.23
    10, 585.7

    and so on,

    Please advise

    Table example.xlsx
    Last edited by pejaemma25; 04-10-2014 at 02:16 AM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: How to generate table from cumulative table?

    Hi and welcome to the forum

    It would probably be easier to assist you if you provided a sample workbook, showing what you have and what you want.
    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    04-09-2014
    Location
    Melaka, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How to generate table from cumulative table?

    tq boss

+ 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] How do I get an entry in one table to generate the rows in an additional table?
    By Gavalar in forum Word Formatting & General
    Replies: 4
    Last Post: 04-16-2014, 08:07 PM
  2. Cumulative addition from table
    By Africa in forum Excel General
    Replies: 0
    Last Post: 05-16-2012, 10:20 AM
  3. Cumulative Frequency Table and Pivot Table
    By ryue65 in forum Excel General
    Replies: 2
    Last Post: 12-10-2009, 04:50 PM
  4. Using Macro to link sql table to generate Pivot Table
    By Benard in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-22-2008, 06:02 AM
  5. [SOLVED] Add a cumulative count to a pivot table
    By Alexandre in forum Excel General
    Replies: 0
    Last Post: 06-09-2005, 11:05 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