Results 1 to 6 of 6

Cumulative percent complete

Threaded View

  1. #1
    Registered User
    Join Date
    01-08-2011
    Location
    Edmonton, Alberta
    MS-Off Ver
    Excel 2003
    Posts
    3

    Cumulative percent complete



    Please see attached the JPEG and Excel files.

    I have four columns in the excel spreadsheet. They are;
    1 - Seq #
    2 - % Chg
    3 - *** % Chg
    4 - For Seq#

    The formula should start calculting cummulative percent complete from next row (for example for sequence # 1 - cummulative should begin from row #2 as highlighted in red in attached excel sheet) and keep on calculating *** % complete till the criteria of = or > 10% is achieved then the cummulative percent complete value is displayed in *** % Chg column and the sequence number for which cumulative percent change criteria is met should appear in For Seq# column.

    Your help will be highly appreciated.

    Thanks

    Zooom
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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