Find first three Non Blank in a row and then run a formula only through those

[Sreeram1686]

Hi Friends, help me please

The situation is this.. I am running a pricing model. Every time I have a new recruit, I need to add 10% of the recruit cost to the first three months from the recruitment. Meaning, if the person joins on Apr, then the cost needs to be added only for Apr, May and Jun.. That way the formula should decide based on the start date, then apply it only on the first three months. Attaching a sample excel for easy understanding.

Please help !!

Cheers
Sreeram

[Xx7]

Try this..

[Sreeram1686]

I must say that your ability is true amazing. thank you much !!

I am still trying to understand if this perfectly works. But looks ok.. thank you again !!

[Sreeram1686]

Hi Xx7, All working fine.. But a small questions.. which I tried solving but couldn't

For Eg, when the number goes down from 5 to 4, then the calculations has some problem. Assuming we have in the series of months 1, 1, 1, 2, 2, 1, 1, 1, 1, 1, 1, 1.. Then the calculation for three month is not working.

Please help !!