MAX date with conditions

[a7024782]

Please I need help. Excuse my English, I use Google translator.
I need a formula to solve:
I have a data range A2: B15, in column A record dates, in column B the variables X, Y and Z.
I need to count the occurrences, only of X and Y, and know which is the greater of the two, if the number of greater occurrences is after the last date of the lesser occurrence, the greater occurrence will be shown as a result.
Example:
1- If Σ X> Σ Y first date X> last date Y = X
2- If Σ Y> Σ Z first date Y> last date Z = Y
If other <> to 1 or 2 = XX
I use Excel 2016. Thanks for your help

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: MAX date with conditions
and Max date with condition
and MAX date with conditions - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.