Forum Discussion
Excel
Hi I have a Staff rota and I would like to create a list of staff availability based on date for staff who are not on shift or have booked holiday. I NEED TO SHOW STAFF WHERE CELLS IN COLUMN C a...
Let me interpret your requirements this way:
1. You want to know which persons are available on a specific date;
2. A person is available if the entry as of such date is blank, "H", or "R";
3. Given the date in B19, the available persons are listed starting in B20; and
4. The list must be sorted in ascending order according to the corresponding value of the available persons in Column C.
Please comment on my foregoing interpretation.
1. You want to know which persons are available on a specific date;
2. A person is available if the entry as of such date is blank, "H", or "R";
3. Given the date in B19, the available persons are listed starting in B20; and
4. The list must be sorted in ascending order according to the corresponding value of the available persons in Column C.
Please comment on my foregoing interpretation.
Please go through the excel file hope this will fulfill your criteria.
That is amazing but not quite as I need it.......
If Column D contains N/A and Columns E to M are Blank or H then that person is Not Available
Also as columns D to M are updated I need to see the list update accordingly
