Results 1 to 5 of 5

Count the number of occasions

Threaded View

  1. #1
    Registered User
    Join Date
    03-16-2009
    Location
    London, UK
    MS-Off Ver
    Excel 16.78 on Mac - Office 365.
    Posts
    80

    Count the number of occasions

    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
    Last edited by deemo; 05-22-2009 at 12:36 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1