Forum Discussion
=FILTER and =MAX(FILTER issue
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