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:
user company
user1 a
user2 b
user3 c
user4 b
user5 c
Any help would be great
Bookmarks