Hello, here is an example data set I am dealing with and what I am trying to find a formula for:

In reality, I have about 85 tasks.  In the second table, I want it to return for each day, the Tasks that are marked with an X in the top table.  The tasks can change depending on the week, and the number of tasks per day can also change, so I need the output to be able to return the task name in Column 1 for all rows marked with an X for each day of the week.  I hope this makes sense.

Thank You  

​Hello, here is an example data set I am dealing with and what I am trying to find a formula for:  In reality, I have about 85 tasks.  In the second table, I want it to return for each day, the Tasks that are marked with an X in the top table.  The tasks can change depending on the week, and the number of tasks per day can also change, so I need the output to be able to return the task name in Column 1 for all rows marked with an X for each day of the week.  I hope this makes sense. Thank You    Read More

​