Thread: Random Numbers
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
  
Posts: 2,819
Default Random Numbers
place 1 - 20 in column A, in column B put RAND(), select a1:b2, Sort on
column B.

The Rook wrote:

I am wanting to generate random numbers from 1 to 20 in cells A1 to A20, but
have no duplicates.

How can I do this?

Reply With QuoteReply With Quote