Count The Number Of OccasionsMay 22, 2009
My data is a list of (in reality 3000x larger). users and the company they belong to. I want to find out how many companies have 1,2,3,4,5 and more than 5 users. Any idea? I am using a pivot table to find out the number of users per company (easy so far) but then I get stuck when I want to use a countif with getpivotdata...
Example of my 2 columns: