Hi,
I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, automatic simulators and charts drawing) as an Industrial Engineer at Michelin. I am always keen to improve my work quality and productivity and, to achieve these goals, I made complex Excel sheets to automate my tasks and eliminate errors.
You can find in my portfolio one excel file with an automatic timekeeping sheet where I used an array formula to match data considering multiple criteria. This file is similar with your request and I can do it for you if you will give me this opportunity and I am sure you will be satisfied with my professionalism and the quality of my work.
Best regards,
Florin Enache.