•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Filter in groupby not working
I'm trying to do a groupby with the below formula:
=GROUPBY(A1:A9,HSTACK(FILTER(B1:B9,C1:C9=D1),B1:B9),SUM,1,1,3)
Column A: Region
Column B: Count
Column C: Date
D1: Date I'm filtering by
I'm trying to use groupby to have one column just from a specific date, and a second column with a total of all dates. Is there a reason that the filter does not work for looking at a specific date?
[link] [comments]
Want to read more?
Check out the full article on the original site