Randbetween 1 and 20 and get all the values

[YasserKhalil]

Hello everybody

In range("E1:E20") I put this formula to get random numbers between 1 and 20

Please Login or Register  to view this content.

I want to get the results to be unique not to be duplicated.. Is there a way to do that?

[alansidman]

In a helper column type =Rand()
then in Column E, type =RANK(F1,$F$1:$F$20) and copy down

Assume column F is your helper column

[YasserKhalil]

Thanks a lot Mr. alansidman

Is there UDF Function that can do that task?

[kalak]

Please Login or Register  to view this content.

[YasserKhalil]

Mr. Kalak you are a great man.. really fantastic wonderful
I try to begin my results in B2 but I failed .. what should I change to achieve that?
Thank you very much sir

[YasserKhalil]

Ok thanks I got it

Please Login or Register  to view this content.