(please see the attached file) I would like a single formula that I can copy down in Column E.
I can get only the first 5 values (Release 1 and first row of Release 2) to calculate properly. How do I calculate the rest of it? Each release starts from 0.
Last edited by wolfgang713; 06-27-2013 at 07:39 PM.
In E6
=IF(C6<>"",0,INDEX($D$6:D6,MATCH(LOOKUP(99^99,$C$6:C6),$C$6:C6,0))-D6)
Copied down
Last edited by Ace_XL; 06-27-2013 at 05:13 PM.
Life's a spreadsheet, Excel!
Say thanks, Click *
Thank you. Please see attached file with the result. For some reason the formula puts a 0 in E9 and E13. Can you adjust it?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks