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

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

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