• 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.

Listing loan and repaid amounts in months

Ufoo

Member
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
 

Attachments

  • Book1.xlsx
    10.6 KB · Views: 8
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?
 
Back
Top