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...
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
