Forum Discussion
=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?
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 ) )
- 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?If you run 365 and already have it, easy with GROUPBY:
=GROUPBY( Table1[House], Table1[Date], MAX,, 0 )or (with Headers):
=GROUPBY( Table1[[#All],[House]], Table1[[#All],[Date]], MAX, 3, 0 )
