Hello,
I am trying to create a random menu of meals to eat. I have made a list of 20 meals and I want excel to spit out 10 of those 20 at random which I have achieved, some meals have multiple options so I have a if x then a variation pops up as well. It is all working well but I am getting repeats. Is there a way to create my list of 10 with sub categories chosen without getting any repeats? The formula I am using in column G is - =RANDBETWEEN(1,20) with the formula in column H being =IF(G4=1,RANDBETWEEN(1,4),IF(G4=6,RANDBETWEEN(1,3),IF(G4=7,RANDBETWEEN(1,3),IF(G4=15,RANDBETWEEN(1,2)))))
Also, how do I get it to spit out a name rather than the number that coorisponds to the meal?
example.jpg
Thank you in advance for looking and helping me out.
Bookmarks