Forum Discussion

simont485's avatar
simont485
Copper Contributor
May 13, 2019

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...
excel
simont485's avatar
simont485
Copper Contributor
May 13, 2019

Twifoo 

 

That is correct! Except point 2..........Blank and H only....not R. (my mistake.)

  • simont485's avatar
    simont485
    Copper Contributor
    May 13, 2019

    Gourab Dasgupta 

     

    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

     

    • TheAntony's avatar
      TheAntony
      Iron Contributor
      Aug 03, 2020

      simont485 , I know that this is an old thread, but the new Excel Dynamic Arrays make the solution easy. If you have the latest update of Excel 365, this should work as you asked.

Resources