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
Bookmarks