+ Reply to Thread
Results 1 to 4 of 4

Pivot table for a series of events: how do I count how many events each company attended?

  1. #1
    Registered User
    Join Date
    08-24-2020
    Location
    New York
    MS-Off Ver
    2016
    Posts
    10

    Pivot table for a series of events: how do I count how many events each company attended?

    I have a list of individual attendees for a recent series of events. So my fields are “event,” “company,” “individual” and “attended (Y/N).”

    I want to see how many events each company attended but I can only seem to count up the total individual attendees. How do I adjust the table to just show the total amount of events attended per company?

  2. #2
    Registered User
    Join Date
    08-24-2020
    Location
    New York
    MS-Off Ver
    2016
    Posts
    10

    Re: Pivot table for a series of events: how do I count how many events each company attend

    Here is an example of what I have and what I want to achieve.

    Attachment 759039

  3. #3
    Registered User
    Join Date
    08-24-2020
    Location
    New York
    MS-Off Ver
    2016
    Posts
    10

    Re: Pivot table for a series of events: how do I count how many events each company attend

    I have no idea how to delete this post but I figured out the answer. Had to use distinct values.

  4. #4
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Pivot table for a series of events: how do I count how many events each company attend

    no problem, your attachment is invalid, so it doesn't need to be removed.
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calendar with auto-populating events (multiple events in a single date)
    By zankzank in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-20-2021, 09:41 AM
  2. Replies: 2
    Last Post: 12-30-2018, 07:51 AM
  3. Counting number of events/pivot table/graph
    By nberm in forum Excel General
    Replies: 7
    Last Post: 07-18-2014, 11:56 AM
  4. pivot table click events
    By G0liath02 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-03-2009, 03:20 AM
  5. How to Generate a calender of Events from data/ Pivot Table
    By MillieDileo in forum Excel General
    Replies: 0
    Last Post: 05-10-2006, 11:10 AM
  6. [SOLVED] Pivot Table Events
    By Blue Aardvark in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2005, 05:05 PM
  7. Pivot Table Events
    By Jim Thomlinson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-29-2005, 10:06 AM

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