Hey ,
I would like to make a randomlist of three items for each day of the week.
I have a list of 28 items I can chose of.
With the function RANDBETWEEN it works but sometimes it gives me twice the same item in the same day. And every time I re-open the file it gives me another shortlist of items.
So, my question is how to prevent RANDBETWEEN to chose an item more than a given number each week ( Let's say no more than twice., and most of all. How to avoid it gives another value everytime I open the file.

Thanks in advance for the help.
Fre.