• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Breaking Total Amount Monthwise

Hi All

Good day

Please find the attached file for my query.

I have data in Column A and Column B.

Column A is Total Amount

Column B is No of Months

Column C to Column N are the Months

Now, the requirement is if the Column B is 12, the Total Amount to be divided equally from Column C to Column N

and

if the Column B is 10 , the Total amount is divided equally from Column C to Column L

and

if the Column B is 3, the Total Amount is divided equally from Column C to Column E

and

Likewise for the otherwise others

Hope you guys could be of help for me.

Thanking you in advance.

Regards
Ramana
 

Attachments

Top