Forum Discussion
Solved
=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...
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 ) )
I can't seem to get =GROUPBY to work, what I read about it is that it's not available to me
but yes, you get the idea of what I'm wanting to do. is there another way?
I apologize in advance for how simple this probably is for some people like yourself but I'm a new user, still learning.
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 )
)Hope you're doing well...
Thank you again.
I hope you're doing well too