Forum Discussion
Counting unique values with multiple criteria
I'm a pretty basic Excel user, and trying to gather some data about our application's clients. Suppose I have this: MONTH IRRELEVANT1 CLIENT IRREL2 SITE STATUS JAN X 1 Y 101 ACTIVE JAN X 1 Y 10...
It seems you need GROUPBY() and PIVOTBY() functions. Try-
=GROUPBY(HSTACK(A2:A27,C2:C27),C2:C27,COUNT,0,0,,F2:F27="ACTIVE")Count by month.
=PIVOTBY(C2:C27,A2:A27,C2:C27,COUNT,0,0,,0,,F2:F27="ACTIVE")
Thanks much for the guidance! The piece I'm not sure how to address is the fact that this data grows by about 10,000 rows per week. It's built using Get Data > File > Folder. And then when a new file is dropped in there, I simply refresh and the new rows come in from the new file.
How would I make this work with a growing data set?