Hi there, welcome back!
I won’t be able to help here, as I still mostly do VBA stuff. Formulas which I think you are interested in are not really my thing, especially things like MAXIFS , since they are only available in Excel since 2019. I tend personally to favour older stable Excel versions. (Bare in mind that if you figure out a solution using MAXIFS, then you can only use it in Excel versions of 2019 + )
Alan
Bookmarks