Unique integer Radom number genrate

[amolryeolekar]

I want to generate unique integer random numbers .I want to copy in A1:A26 (for say 25 random numbers , here "amount" meanse number of random numbers may be varry) or up to amount mentioned should copy each random number in each cell serially but due to array I may be not able to copy in cell.Pl. suggest

Please Login or Register  to view this content.

[patel45]

Please Login or Register  to view this content.

[amolryeolekar]

By this I can get duplicat random nos. In the function it creates 25 rnd nos. But in one cell I want the same generated nos. But in a1:a25 cells

[patel45]

you provided the function, I suggested the usage.

[amolryeolekar]

Not giving results as expected all 25 random nos. are showing in 25 cells . i want each random no in each cell.

[Jakobshavn]

Give this a try:

Please Login or Register  to view this content.

[amolryeolekar]

Thanx it is solving my purpose, but not as a function .
It could have been better if i could use it as a function .