• 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.

How To Assign Shift Randomly?

Kenshin

Member
Hello guys it is nice see you again, i have a problem and need a hand here, please see the attach file

thank you
 

Attachments

  • Assign Shift.xlsx
    11.3 KB · Views: 3
See attached file with helper formula way.

Press F9 for re-calculation.

Regards
Bosco
 

Attachments

  • Assign Shift.xlsx
    14 KB · Views: 8
Last edited:
Thanks Bosco appreciate, but how if i add up some more tables, i try the formula but no luck


thank you
 

Attachments

  • Assign Shift.xlsx
    14.7 KB · Views: 3
Back
Top