# Count The Number Of Occasions

May 22, 2009My 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:

usercompany

user1a

user2b

user3c

user4b

user5c