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

 

[AliGW]

Cross-posted: https://www.excelforum.com/excel-formulas-and-functions/1361811-max-date-with-condition.html

 

[vletm]

a7024782
You should reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

There are clear sentences if someone uses Cross-Posting.

 

[Fluff13]

Also here https://www.mrexcel.com/board/threads/max-date-with-conditions.1184890/
and on Ozgrid