I'm looking at creating a column which gives me a random number every time data is changed. I know the formular to do this, however I'm just wondering if there is a way that I can potentially make the results as even as possible?
With the data I've got I will never get an even split as there is never an even number to work with, however I'd like to get it as close as possible if this is acheivable.
The randomise will only be between 1 & 3 so a limited numberset, but just want the formula to work out so its a random selection.
Bookmarks