•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
Tagged with
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#Excel compatibility
#formula generator
#Excel alternatives
#GROUPBY
#FILTER
#HSTACK
#SUM
#Region
#Count
#Date
#specific date
#total of all dates
#filtering
#Excel