Help with formula

[twiley23]

I was looking to see how to assign a word to certain numbers and make them random. Also the word would need to have an assigned # of
How many times it will show up.

For example:

# Friday Saturday Sunday

1
2
3
4
5
6
7
8
9
10
11

The word bacon will only show up 1 time on either the number 2 or 10 and be placed under Friday, Saturday or Sunday randomly

The word eggs will show up 2 times on either number 1 or 11 and be placed under Friday or Saturday or Sunday randomly

Thanks , please let me know if this is even possible.

 

[Snakehips]

@twiley23 I have used the Copy icon (to left of Column letter A) to copy then paste my posted XL2BB solution back to a fresh sheet and it is working perfectly for me. No issue with allocating bacon or anything else.
Did you copy/paste the XL2BB ? Are your data ranges exactly the same? Maybe take a look to double check the formulas you have in rows 3 and 10.

If you continue to have issue then please download XL2BB and post back with your mini sheet showing what you have.

 

[twiley23]

@twiley23 I have used the Copy icon (to left of Column letter A) to copy then paste my posted XL2BB solution back to a fresh sheet and it is working perfectly for me. No issue with allocating bacon or anything else.
Did you copy/paste the XL2BB ? Are your data ranges exactly the same? Maybe take a look to double check the formulas you have in rows 3 and 10.

If you continue to have issue then please download XL2BB and post back with your mini sheet showing what you have.

Awesome !
Thank you , I will try when I get home , can I message you with some follow up questions ? Thanks

 

[Snakehips]

Yes that's fine with me.