Filtering

Occasional Visitor

Hello!

 

Wondering if anyone has any suggestions to help me create a document in excel. 

 

I am creating a event running order and need to assign roles to people, so that the document can be filtered for each person with their roles only.

The issue I have is that on some parts, there will be 2, 3 or more people who will require that specific role. 
If I create a column 'Who', I then input the persons initials, eg. JH, I don't want to be putting several initials in 1 column eg, JH, TK, MW, as I want each person to have their own. 

 

Is there a way I can create something so that it can do what I need?Capture.PNG

1 Reply

@IC-Jade What stops you from creating one row for each host and assign the same task or separate ones to each of them?