Forum Discussion
Create a simple dynamic tally chart via dropdown list WITHOUT a Pivot Table
I have this Data set on "Sheet 1": User ID Call Reason Product ID Date Created 165 Billing 1229509 1/16/2020 165 Billing 1644846 1/29/2020 165 Billing 1569706 1/30/2020 ...
mtarler Its a part of an entire dashboard, so I need to be able to do it without it being a pivot table.
shade206 ok, so no pivot table. As I mentioned I did include a formula based solution also in column G (peach colored). If you have array functions you can simplify it using:
=COUNTIFS(Data!$A:$A,$C$3,Data!$B:$B,E3:E7)
and only need to enter that and not have to 'fill down'
I also included C6 drop down which is a handy trick to make that drop down filtered based on partial info you enter into the cell. Let's assume you have 300 names you type "da" and it filters the list to only Davids and Daves and Linda etc... instead of 300 names.