Nov 18 2021 08:52 AM
I have 5 employees and we work Monday through Wednesday. I only need 2 employees per day.
so i want to make a random number between 1-5 which represents my 5 employees for my first cell, my second cell for that day i want a random number between 1-5 that excludes what ever number is in cell 1. for the second day i want a random number between 1-5 that excludes cell 1 and 2 of the first day. than for the second cell of that day i want a random number between 1-5 that excludes day 1 (cell 1,cell2) and day 2 cell 1. and that lastly Wednesday i was cell 1 to be between 1-5 minus the 4 other cells. and the last cell of Wednesday will be 1-5 minus what ever else is in that cell
Nov 18 2021 09:16 AM
See the attached sample workbook.