I have gone through your requirement, and I certainly believe that I'll be able to help you out with an easy solution, with accuracy and in minimum turn around time. The solution will be so easy that you will be able to use it without any problems. Even after the solution is provided, I'll be available for any (reasonable) revision that you may require.
I have years of experience working with advanced features of Excel, including Complex Calculations, Formulas, Functions, Data Management, Data Cleaning, Reporting, Charting, Pivot Tables, Macros, VBA Code for small projects.
Let's get in touch over a chat to discuss the details and cost, etc.
Best Regards,
Imran Latif