Hi,
We are expert in Excel based tools, dashboard and reporting. We can very much capable of doing the search operation inside the excel and then apply logical calculations to get you the final numbers.
If you can share sample of your data, we can send back a dummy design and then yiu can decide.
Kindly message for further discussions.
Regards,
Pal