Here is what I got: So I had to resort to the RAND function.
It works well with a negligible probability of the numbers repeating (I tested it multiple times on more than 100,000 cells, and there were no repetitions.
These random name pickers reveal a single result each time. You can also click "remove" to stop the same name being drawn again.(Thanks to Mrs. Benedict Catholic School for the fantastic "remove" name idea!
)Randomly choose three names - drawn in order: 1st, 2nd, and 3rd place.
First load the folder that contains all those files you want renamed.
Usually you do this by right clicking on a folder and selecting “Bulk Rename”.Great for choosing winners for prizes or competitions - With a first place winner, then runner up prizes for second, and third place.One way to generate random numbers in Excel is with the RAND function.Microsoft Excel provides a handful of different sorting options including ascending or descending order, by color or icon, as well as custom sort.However, it lacks one important feature - random sort.Fortunately, the solution to this problem can be achieved using special, but not difficult, settings in this nice freeware called Bulk Rename Utility.It is not obvious how you can enjoy random renaming, but it is easy.Then go to the “Action” menu and select “Random Sort“.This will change the current order of your files, which normally follows their current names or modification dates, etc.If you are generating a lot of random numbers, you can test it once).Here is how you can use the RAND function to generate a set of unique random numbers in Excel: While I checked and didn’t find repetitions in the result of the RAND function, I still recommend you check once you have generated these numbers.