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?