Hello everyone - I could certainly use some help, please…
Col CS is a running total of sums. (But not every row contains a sum.)
Col CT, (helper column) I have:
=MAX(CS2,CT1)
Col CU has:
=IFERROR(IF(CS2=CT2,0,MAX(CU1,CT2-CS2)),"")
to help find the drawdown of theses sums, until a new recovery high is reached.
I have this:
=MAX(CU:CU)
Finding the max drawdown of CU.
Essentially, what I am after is to know how many rows after that lowest (Max) drawndown it took before the recovery high (from that Max drawdown) was reached.
Any and all help, much appreciated - Thanks!
Col CS is a running total of sums. (But not every row contains a sum.)
Col CT, (helper column) I have:
=MAX(CS2,CT1)
Col CU has:
=IFERROR(IF(CS2=CT2,0,MAX(CU1,CT2-CS2)),"")
to help find the drawdown of theses sums, until a new recovery high is reached.
I have this:
=MAX(CU:CU)
Finding the max drawdown of CU.
Essentially, what I am after is to know how many rows after that lowest (Max) drawndown it took before the recovery high (from that Max drawdown) was reached.
Any and all help, much appreciated - Thanks!
