Ten14
New member
- Joined
- Jul 6, 2013
- Messages
- 2
- Reaction score
- 0
- Points
- 0
I need to equally but randomly schedule list of 7 doctors into weekly call schedule that runs Tuesday thru Tuesday. Current manual version has doctors’ names one per cell across top row (D1 thru J1), and start date (A2 thru A27) then stop date (B2 thru B27) in 1st 2 columns. Next column is blank (c2 thru C27) to insert doctor name (formula I need), but ONLY if the word YES appears in the same row for that week opposite their name - starting with D2 thru J2 for the first week) (meaning they are available that week).
:help: Doing this manually is so inefficient!
Hope I make sense. If there is a better way to set it up, I'm happy to accept any and all assistance as I only know basic Excel.
Thank you.
Just figured out I could attach my example...hope it is helpful in finding a fairly easy solution. ray:
:help: Doing this manually is so inefficient!
Hope I make sense. If there is a better way to set it up, I'm happy to accept any and all assistance as I only know basic Excel.
Thank you.
Just figured out I could attach my example...hope it is helpful in finding a fairly easy solution. ray:
Attachments
Last edited: