Results 1 to 5 of 5

Macro to count number of participants went to each specific event by month & by event type

Threaded View

ajang Macro to count number of... 11-07-2012, 01:56 PM
JieJenn Re: Calculate number of... 11-07-2012, 02:13 PM
ajang Re: Calculate number of... 11-07-2012, 03:13 PM
JieJenn Re: Macro to count number of... 11-07-2012, 03:54 PM
ajang Re: Macro to count number of... 11-07-2012, 04:02 PM
  1. #1
    Registered User
    Join Date
    10-13-2010
    Location
    Miami, US
    MS-Off Ver
    Excel 2007
    Posts
    83

    Macro to count number of participants went to each specific event by month & by event type

    Hi,

    I asked a somewhat similar question before when asked for a Macro. However, I have one more item added in this file, so not able to figure out the Macro for this.

    What I am trying to do is see how many sessions each participant attended in a specific month for specific event. It is possible that each participant would have gone to more than one workshop in one month.

    I need a column for client name, then service type, followed by number of sessions he/she attended for that service type and this comes from service dates. Pivot table adds and gives you grand total for dates for a month, so I use that column. However, I have to split my data by months else it gives me grand total. But anything straight would also do, I just need to know how many sessions each participant attended by month and by service type. Please see the attached file for variables and results of pivot table.

    Thank you so much for all the help,
    Ajang
    Attached Files Attached Files
    Last edited by ajang; 11-07-2012 at 03:14 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