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
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?