+ Reply to Thread
Results 1 to 3 of 3

Attendance Planning for an Event

Hybrid View

  1. #1
    Registered User
    Join Date
    09-09-2006
    MS-Off Ver
    Excel (Office 365 ProPlus)
    Posts
    47

    Attendance Planning for an Event

    Hi All

    Looking for some help with some attendance planning for an event.

    I have a list of people, and sessions they would like to attend, and which function they work in.

    I would like to create a matrix which places the names of all the individuals who have registered in the correct box in the matrix. Example attached.

    Thankful for any help as always!

    Jay

    Attendance Planning.xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Attendance Planning for an Event

    Hi Jay
    I would suggest a Pivot Table Approach. See sample attached.
    Tony
    Attached Files Attached Files

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,408

    Re: Attendance Planning for an Event

    See attached file.

    I've put these formulae in the helper columns in the cells stated:

    F4: =B4&" "&C4
    G4: =D4 & E4
    H4: =G4&"_"&COUNTIF(G$4:G4,G4)

    These are coloured blue for clarity and then copied down - you can hide these columns if you wish.

    Then I have this formula in L5:

    =IFERROR(INDEX($F:$F,MATCH(L$4&$K5&"_1",$H:$H,0)),"")&IFERROR(CHAR(10)&INDEX($F:$F,MATCH(L$4&$K5&"_2",$H:$H,0)),"")&IFERROR(CHAR(10)&INDEX($F:$F,MATCH(L$4&$K5&"_3",$H:$H,0)),"")

    You need to format this cell to allow text to wrap, then you can copy the formula across and down as required.

    You will need to correct the spelling mistake for Session 4 in column D.

    Hope this helps.

    Pete
    Attached Files Attached Files

+ 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. [SOLVED] Bar Code Reading Templates to track attendance at a event
    By quedog20 in forum Excel General
    Replies: 19
    Last Post: 03-02-2020, 11:16 AM
  2. Replies: 10
    Last Post: 03-17-2016, 05:34 AM
  3. Bubble Chart Help - Event Cost/Date/Attendance
    By MrPlow2 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-02-2014, 02:37 PM
  4. Replies: 3
    Last Post: 06-12-2011, 02:56 PM
  5. VBA for planning
    By chris85 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2010, 04:07 PM

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