11th November 2014, 05:20 PM
|
|
Member
|
|
Join Date: Nov 2013
Posts: 602
|
|
Re-using some of those inelegant formulas again (though it has its advantages as well)
In D2:
Code:
=IF(A2=A3,IF(B2>B3,B2,-B2),B2)
In E2:
Code:
=IF(C2="Close",SUM(INDIRECT("D"&F2&":D"&G2)),"")
In F2:
Code:
=IFERROR(IF(A2="","",IF(NOT(A2=A1),ROW(),F1)),"")
In G2:
Code:
=IF(F2=F3,G3,ROW())
Fill Down.
Remember me when you earn too much money to spend...  |