randbetween excluding multiple cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2981338%22%20slang%3D%22en-US%22%3Erandbetween%20excluding%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2981338%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%205%20employees%20and%20we%20work%20Monday%20through%20Wednesday.%20I%20only%20need%202%20employees%20per%20day.%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20i%20want%20to%20make%20a%20random%20number%20between%201-5%20which%20represents%20my%205%20employees%20for%20my%20first%20cell%2C%20my%20second%20cell%20for%20that%20day%20i%20want%20a%20random%20number%20between%201-5%20that%20excludes%20what%20ever%20number%20is%20in%20cell%201.%20for%20the%20second%20day%20i%20want%20a%20random%20number%20between%201-5%20that%20excludes%20cell%201%26nbsp%3B%20and%202%20of%20the%20first%20day.%20than%20for%20the%20second%20cell%20of%20that%20day%20i%20want%20a%20random%20number%20between%201-5%20that%20excludes%20day%201%20(cell%201%2Ccell2)%20and%20day%202%20cell%201.%20and%20that%20lastly%20Wednesday%20i%20was%20cell%201%20to%20be%20between%201-5%20minus%20the%204%20other%20cells.%20and%20the%20last%20cell%20of%20Wednesday%20will%20be%201-5%20minus%20what%20ever%20else%20is%20in%20that%20cell%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2981338%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2981527%22%20slang%3D%22en-US%22%3ERe%3A%20randbetween%20excluding%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2981527%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1222976%22%20target%3D%22_blank%22%3E%40nubsterperry%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20sample%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

2 Replies

@nubsterperry 

See the attached sample workbook.

@Hans Vogelaar   Thank you so much!