via https://youtu.be/h966t3oZhEc

In this video, I show you how to randomize a list in a column in Excel. For this example, I entered my list in column A, then used the RANDBETWEEN function to generate random numbers in column B. I then sorted columns A & B in ascending order by column B to randomize the contents in column A.

The formula I used was =RANDBETWEEN(1,1000). It’s not necessary to avoid duplicates, but it may help achieve more randomization.