Is it possible to select a name and it outputs all the days that employee worked below the name from a table?
For example, Jim is selected from the drop down menu. Then the formula below will have the days Jim worked and the grey condition is duplicate. The data if the days Jim worked is on another sheet as a table.
Or
Is there any way to have a calendar / Pivot table to accomplish this?
For example, Jim is selected from the drop down menu. Then the formula below will have the days Jim worked and the grey condition is duplicate. The data if the days Jim worked is on another sheet as a table.
Or
Is there any way to have a calendar / Pivot table to accomplish this?
