Results 1 to 7 of 7

random number generator

Threaded View

  1. #1
    Registered User
    Join Date
    10-17-2011
    Location
    romania
    MS-Off Ver
    Excel 2010
    Posts
    25

    random number generator

    i want to build a random number generator, that picks the numbers from which to generate from a list that i supplie, and i found this formula:
    
     =INDEX($B2:$B21,RANDBETWEEN(1,COUNTA($B2:$B21)),0)
    the thing is that i need to generate numbers in 4 diferent cells, and i need them to be diferent

    the attachment may be a little more clear.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1