Hello, my name is Anuradha and I am an expert in Microsoft Excel. With over 4 years of experience in Excel projects involving data management, Excel automated dashboards, report generation and applications, I am confident that I can deliver the best results for your project.
I understand from your description that you need to allocate payments to bills on a FIFO basis in Excel and want to know which bills have been allocated to a particular payment number. Specifically, you have three scenarios:
1) Multiple payments to a single bill
2) Single payment to single bill
3) Single payment to multiple bills.
I believe I am the best fit for this project due to my expertise in Excel formulas, specifically advanced Excel (complex formula, array, lookup, pivot table, conditional formatting, dynamic dashboards). Additionally, I have experience in data entry as well as working with MS Office and Google Sheets/Form/Slides.
I would love the opportunity to discuss further how I can help bring your vision for this project to life! Please feel free to reach out if you have any questions or would like more information about me or my skills.