Randomize as equally possible

[mahmed1]

Hi

I have a list or Agent Names from column A
Say first set of rows is A2:A50

I want to generate random number between 1,3 but want to make sure its eventually spread or as even as evenly possible

How can I achieve this tweaking this randbetween formula
=Randbetween(1,3)

 

[Eric W]

Yes, that looks like you figured it out. Does it work?

 

[mahmed1]

Hey yep that worked beautifully thank you