Forum Discussion
Help and Old Man Out Please
I have attached a worksheet that illustrates the two problems that I am having. The spreadsheet has comments in cells that shows what I am trying to accomplish. The spreadsheet is just an example o...
I'd suggest to add helper column D
with formula
=IF($B21,1-$E$13,D21+1)and next column E will be as
=IF(
(IF($B21,1-$E$13,D21+1) <1) + (IF($B21,1-$E$13,D21+1) >$E$15),
0,
INDEX($E$2:$E$11,IF($B21,1-$E$13,D21+1))
)formulas start from row 22, drag them down till end of the range.
I forgot to adjust these formulas for very first row (#21 here), thus to simplify let consider it as helper row in which A21 and B21 are always equal to 1.
Sergei,
Once again thank you so much. If you would be so inclined please email at mailto:jack@phelanmail.com
I would like to tell you something that I prefer not to do on a public forum.
Jack