• 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


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

Listing loan and repaid amounts in months


Hello excel gurus, please find the attached excel sheet. I need a formula that will list all loans and repayment in their respective months for each person. The formula should work for many people and many months. Please help. Thanks



Active Member
Do you need us to solve the entire project for you?
Forums are made to help people when they have tried to solve a problem and are stuck.
You do not seem to have tried anything?
FWIW one of your dates is text, and using merged cells is a very bad idea
Rearrange your data so that it can be used in a Pivot Table?