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...
An alternative could be Power Query with a Pivot Table. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table. Then you can right-click in any cell of the Pivot Table and select refresh to update the result of the Pivot Table.
The data layout in the screenshot and in the attached file is for illustration. You can place the green result table and the Pivot Table in other worksheets.