Hi,
I'm new to the forum so I would like to start by saying that this forum has been very usefull in my earlier excel questions. Thank you all for that!
For the following question I can't seem to find an answer so I would like to ask it here:
As a new manager in a firm I'm trying to get an overview of all the tasks of the employees. To get this, I made a table in excel which gives a list of all the tasks in the firm on the one hand, and a list of all the people on the other. With this I get a clear view of how many people are working on the same task or on which task nobody is working on. And it also shows when a certain task is somebodys core task (c), normal task (x) or back-up for the task (b). To give you an idea of what I mean, I put an example (with all fictional names) in the attachement.
Now do I also want to be able to compair the tasks of 2 (or more) employees, but that's where I get stuck. I know I can filter multiple columns by filtering and unchecking the blank cells. The problem is that when I do this, it only shows me the tasks that these employees have in common and it hides the rest.
How can I filter this table in orde to keep all the rows with at least one marking? So for example: I want to compare Tom to Jimmy, how do I get to see all the tasks of Tom and all the tasks of Jimmy and hide all the other tasks? In my example are only a few tasks, but in my real table there are over 300 tasks, so you get why I'm looking for a way to filter in the list .
Thanks in advance for the help.
Bookmarks