• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. K

    VLOOKUP HLOOKUP LISTING NAMES FROM DATA

    Hi All Some time ago I hada thorny question related to creating a work rota from which I could extract days, nights annual leave, sickness along with a few other nuggets. After posting on this forum I was pointed in the right direction. . After some fiddling I cracked the problem with VLOOKUP...
  2. K

    Rota question

    Some time ago I asked about how count text values in a rota to enable counting the number of staff on duty. Thank you for the assistance as I am now using COUNTIF with good results. My new question is this. Having a table with a column with staff names. Then a series of date columns below...
  3. K

    Have Excel count in a rota to determine number of staff on duty by grade.

    I have to create a simple rota which requires to indicate The number of staff on duty The number of each grade on duty Any short fall or over staffing e.g. have the shortfall show in RED To make things easier to ready D = Day (10h 43m), N = Night (10h 43m) 9-5 = Regular working day (7h 30m)...
Back
Top