Home » Forums » Open Source Learning Center » Question and Answer

Shift Scheduling (Stuck for 1wk and counting)

Submitted by sean_weijie on 10 March, 2013 - 14:44

Hi,

I have chanced upon this forum and decided to join as I believe in its success.

Please refer to the link for reference.
https://www.dropbox.com/s/0kmpjes783lgju7/Shift-scheduling.xlsx

I am having trouble with shift scheduling and will greatly appreciate any form of solutions/suggestions.

I will need a formula that's able to produce the names available for the camp (reflected in Cell K2). So as such, when K2 changes, the list (Cell K5 onwards) of people available changes too.

Any inputs or suggestions as to how to approach it? Thank you very much!!!

‹ Digital Signature Expiration - Company Out Of Business Check range A10 to A45 and if cell not empty then same line in B must have numeric value. ›
»
Almir's picture

Try Advanced Filter

Submitted by Almir on 10 March, 2013 - 22:15.

As you need a list of names as the result, I suggest using Advanced Filter, with Camp A, Camp B etc. as criteria. You could record creating advanced filter as a macro. If you need additional help, please, let me know.

»