Hello,
Sure, I can do that easily, fast and accurate in max 1 day, using Excel formulae and/or VBA code, if this will make things faster. I will need the excel file and the rules you want applied.
A few words about me: I'm developing VBA code and using Excel (functions, charts, pivots, etc...) for more than 15 years, and I'm a trainer for both Excel and VBA (all levels) for 12+ years.
Looking forward to hear from you,
Kind regards,
chriskerpini