![]() |
|
|
Thread Tools | Display Modes |
#2
|
||||
|
||||
![]()
Your link was nonfunctional for me.
It sounds like some days you get a cumulative figure, and sometimes it comes through as zero. Add a column that uses either the prior cumulative number or the number above. E.g. A2=15 A3=18 A4=42 A5=55 a6=0 a7=0 a8=0 a9=80 Then E1=0 E2=if(A2>0,A2,E1) F2=E2-E1 And copy down. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
officeboy09 | Excel | 8 | 10-30-2013 05:38 AM |
![]() |
scott.hannaford | Project | 1 | 10-23-2013 06:22 AM |
![]() |
babapusy | Excel | 1 | 01-21-2013 03:05 AM |
Ignore Resource Work Times | JR_12 | Project | 2 | 12-05-2011 06:35 PM |
![]() |
IanKM | Outlook | 1 | 10-20-2011 11:02 AM |