Hi everyone,

I am from a radio station which runs a daily feature (Monday to Saturday) where listeners guess what year the music is from.

Simply put, we play an hour's worth of music from one year, give clues, and the listeners have to guess.

The years we use are 1962 to 2010.

Planning it each year has proven to be a lot more complicated than it seems, and I wondered if there was a way to get Excel to do it.

I've tried basic randomising functions, but they have provided unsatisfactory results.

When I plan, the following rules must apply:
- Six years should be selected per week (Mon to Sat inclusive)
- The chosen year must be between 1962 and 2010 (inclusive)
- There should be no repeats until there are no more years left to be chosen
- The same year should not appear on the same day of the week at all until there are no more years to be chosen
- The same decade should not appear more than twice a week, unless there is no alternative
- The same decade should not appear on the same day in two consecutive weeks

Could anybody please assist in helping me with implementing the above rules?

I never knew it could be so complicated!!

Many thanks,
Alex