•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Filter in groupby not working
Our take
It seems you're encountering challenges with your GROUPBY formula, specifically in filtering for a specific date. The formula you've provided attempts to combine filtering and grouping, which can lead to complications. The FILTER function may not be effectively isolating the desired date, causing the GROUPBY to misinterpret the data. To achieve the outcome of having one column for a specific date and another for the total across all dates, consider revisiting the structure of your formula.
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]
Read on the original site
Open the publisher's page for the full experience
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