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
Gourab Dasgupta's avatar
Gourab Dasgupta
Iron Contributor
May 13, 2019
what is the purpose of c column, how did you get the number 12, 45, 0 ....
  • simont485's avatar
    simont485
    Copper Contributor
    May 13, 2019

    Column C is an overtime count in hours.....so it will increase as more overtime is done.

     

     

    • Gourab Dasgupta's avatar
      Gourab Dasgupta
      Iron Contributor
      May 13, 2019

      simont485 

       

      why this four person in this list?

      So for 
       02/01/2001
      Person 60
      Person 80
      Person 1012
      Person 724
      • simont485's avatar
        simont485
        Copper Contributor
        May 13, 2019

        Gourab Dasgupta 

         

        Good point...there should only be 3 people in that list!

         

        Person 10 should not be there!!

         

        I'd input the date in B19 and the staff who have the lowest count from column C would appear when column D is blank and the corresponding column under the entered date is blank or contains H

Resources