Max date with condition

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

Thanks for your help, but my Excel 2016 does not have yi MINIFS or MAXIFS available

Thanks for your help, although it did not work as it is, it helped me to find the solution.

Originally Posted by GeoffW283

Here is different attempt. It does not use MAXIFS().

First a question:

In post #1 you say: 2- If Σ Y> Σ Z first date Y> last date Z = Y
But in your sample workbook you say for the Σ Y > Σ Z case; first date Y > last date X = Y
Is it last date Z or last date X? In this formula I have used last date Z. It's easily changeable in the formula - in the last "lookup" change "Z" to "X"

Formula:

Please Login or Register  to view this content.

Let us know if this is what you are looking for.

Thanks for your help, although it did not work as it is, it helped me to find the solution.