• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

MAX date with conditions


New Member
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.
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



Excel Ninja
You should reread Forum Rules
There are clear sentences if someone uses Cross-Posting.