+ Reply to Thread
Results 1 to 6 of 6

Randbetween 1 and 20 and get all the values

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,840

    Randbetween 1 and 20 and get all the values

    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?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,320

    Re: Randbetween 1 and 20 and get all the values

    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
    Alan


    Have you debugged your code?
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,840

    Re: Randbetween 1 and 20 and get all the values

    Thanks a lot Mr. alansidman

    Is there UDF Function that can do that task?

  4. #4
    Valued Forum Contributor
    Join Date
    03-21-2013
    Location
    cyberia
    MS-Off Ver
    Excel 2007
    Posts
    457

    Re: Randbetween 1 and 20 and get all the values

    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,840

    Re: Randbetween 1 and 20 and get all the values

    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

  6. #6
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,840

    Re: Randbetween 1 and 20 and get all the values

    Ok thanks I got it
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Randbetween exactly some values in excel ?
    By Mr.Nob0OOdy in forum Excel General
    Replies: 5
    Last Post: 06-23-2015, 05:49 AM
  2. [SOLVED] Randbetween to take numbers based on the cell values
    By harish.chinni in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-12-2013, 03:17 AM
  3. Replies: 1
    Last Post: 07-19-2011, 08:31 AM
  4. Ommitting some values from randbetween function
    By Geomarsh in forum Excel General
    Replies: 6
    Last Post: 07-27-2009, 07:38 AM
  5. Holding RANDBETWEEN() values
    By SER01 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-04-2007, 12:11 AM

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