Hi, I am attempting to evenly randomize about 500 songs, within weekly song groups of 12, across a yearly calendar. Songs have reference numbers, which are divided into several categories. Some categories are used more than others, thus I need to have duplicate occurrences. The problem is, I need duplicates to have a separation of least 1 month. Right now, duplicates appear anywhere from next to each other on the same day, to 11 months later.

I know just enough about excel and vba to be dangerous, nay, laughably dangerous, so after much dinking around, I'm now asking for help.

I tried dividing the song categories into smaller group listings and reducing date ranges, but the end result is about the same...I have duplicates that have uneven separation.

Given randbetween's very consistent nature, is there something contextually that can be done to perhaps achieve more randomness? I'm a musician, thus my logic in this context is more like an irrevocably flawed and disorganized 3-ring circus, faintly reminiscent of the war-torn back streets of Beirut, which will do more than rot the colons of Satyrs...