Trying to select a row name by column date if a value is present
So, as the title says....
Im making a staffing sheet for work. I would like EXCEL to generate a daily staffing sheet based on the people working on a given day.
the schedule is 6 weeks and the columns auto populate the dates when the new 6 week starts. The employee names are static. The employees work Am or PM shifts which are designated by A, P.
Im terrible with excel and ive finally gotten to a point where youtube can no longer help me (or i simply dont know what to search for)
So, if I input a date, I want just the people (on that date) with an "A" to populate to a group
and the same for those with a P.
ideas?
There would be 9 sheets (each for different units of this hospital) and then...given the day entered on the final "HOUSEWIDE" sheet....it would automatically fill in the spots.
i uploaded the excel file with the test names and "schedule" and how it should look on the housewide sheet
|