7 Replies Latest reply on Dec 7, 2016 10:50 AM by Shinichiro Murakami

    Filter by Last Common Date

    Eleonor Hellblom

      Hi,

       

      I want to filter my data by the last common date - so MAX the month/year that each country had any data (February) but I am struggling to get the calculation.

      Please see the attached workbook, I am looking to filter Sheet 2 by February 2016, but to have this dynamic so it takes the month where all three countries have any data/no blanks.

       

      Let me know if this doesn't make any sense.

       

      Thank you in advance!