EXCEL - Randbetween

[hoym8]

I use the following formula to generate random numbers from 1 to 100 : -

RANDBETWEEN (1,100)

Does any one know : how can i supress the result of preventing any duplication .

T Y

 

[eklass]

"supress the result of preventing any duplication" ?

are you trying to prevent duplication? if so, it's not really "random" because you are influincing the results

 

[petesamprs]

Can you explain a bit more what you mean by "how can i supress the result of preventing any duplication" thx.

 

[hoym8]

I actually wish to generate 10 random numbers at the same time ( across 10 different cells in Excel ) ; however, the result sometimes give me one or two duplicate ones . So , how can i prevent it of doing so ?

 

[hoym8]

any idea ?