Hi folks,

I've 7 numbers (-3 to +3) that I need to distribute randomly (as best we can) 2539 times between other entries.

If possible, as close as we can to the following weights... This is the best way I could phrase it...



-3 -2 -1 0 1 2 3
0.05 0.1 0.2 0.3 0.2 0.1 0.05

Any ideas? I'm sure I've seen a post on here similar to this, and I've tried to mod the following code to suit my needs, but I can't quite get it to work, I think because of the duplicated weights...

=CHOOSE(MATCH(RAND(),{0,0.44,0.6,0.71},1),"A","B","C","D")