Forum Discussion

millerseth528's avatar
millerseth528
Copper Contributor
Oct 25, 2024

=FILTER and =MAX(FILTER issue

I'm Filtering information from this Table but I only want the latest data to show. Why does the =MAX(FILTER formula not populate all the needed data? Could some one please assist, I need all the data from the latest date?

 

  • Lorenzo's avatar
    Lorenzo
    Oct 30, 2024

    millerseth528 

    I can't seem to get =GROUPBY to work, what I read about it is that it's not available to me OK but this doesn't tell us what exact version of Excel you run (2021, 2024 or 365). Don't forget next times please

     

    In the meantime:

    in E3:

    =LET(
      unique_house, SORT( UNIQUE( Table1[House] ) ),
      max_date,     MAXIFS( Table1[Date], Table1[House], unique_house ),
      CHOOSE( {1,2}, unique_house, max_date )
    )
    • millerseth528's avatar
      millerseth528
      Copper Contributor
      Awesome thank you it worked. One more question though if you don't mind helping please. You would be a lifesaver. What if I have 10 different house names all with multiple entries and dates. How would I populate those?
      Like say "A" House's last entry was 11/10/2024 but "B" House's last entry was 11/15/2025 and "C" House's last entry was 12/21/2024? How would I populate those?

Resources