+ Reply to Thread
Results 1 to 3 of 3

Generate specific range of Uniq ramdon from a main range

  1. #1
    Forum Contributor
    Join Date
    10-21-2012
    Location
    miami, florida usa
    MS-Off Ver
    Excel 2007
    Posts
    260

    Generate specific range of Uniq ramdon from a main range

    Hi,

    yes, the post title Sounds weird (sorry)

    Please i need expertise on how to create a sheet to generate Random numbers from 2 specific list
    of a main list range of 36 Numbers. (List A = Specific 15 numbers, List B = The remaining Numbers from these 36)

    Example :

    -The Main List Range is from Number 01 to 36
    -The Specific random list will be 15 Numbers of these 36

    List A-.The Specific 15 Numbers are: 01,02,03,10,11,12,13,20,21,22,23,30,31,32,33
    List B-.Remaining Numbers : 04,05,06,07,08,09,14,15,16,17,18,19,24,25,26,27,28,29,34,35,36

    So

    I need to generate ONE Unique Random Numbers of List A ( 01,02,03,10,11,12,13,20,21,22,23,30,31,32,33)
    In Cell A1
    In Cell A2
    In Cell A3

    And from List B, (04,05,06,07,08,09,14,15,16,17,18,19,24,25,26,27,28,29,34,35,36)
    I need to do the samething In
    Cell A4
    Cell A5
    Cell A6

    A Dummy question.. (sorry, sometime i'm lil dum) : It's possible to have a 6 cells with random but Unique Digits?
    (not repeated numbers between the 6 cell ??)

    IMPORTANT NOTE :
    If i came to this (ask you for help) Is because i already search about RANDOM and
    tried to do it my self Using the RAND and RANDBETWEEN Formula (with no success )


    Thank you so much !!


    Best Regards from Miami

    David

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,691

    Re: Generate specific range of Uniq ramdon from a main range

    Look at this spreadsheet
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    10-21-2012
    Location
    miami, florida usa
    MS-Off Ver
    Excel 2007
    Posts
    260

    Re: Generate specific range of Uniq ramdon from a main range

    Hi Mr Allansidman,

    Thanks for your kindness,

    Thank you so much Sir !!!

    Every day i learn a bit.... Thank you !!!!


    Best Regards

    David

+ 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] Copy and paste range as values to specific sheet/range
    By lukestkd in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-06-2014, 09:48 PM
  2. Copying a range from Wks A to a specific range in Wks B into subseq blank rows in Wks B
    By Tanner2004 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2013, 03:29 PM
  3. Generate uniq ID in cell H5 of sheet1 after putting the value in C6 of sheet1
    By sandy987299580 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-30-2013, 04:02 AM
  4. Copy and paste specific range to date specific range in alternate sheet
    By alanalmarza in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 08:29 AM
  5. Replies: 0
    Last Post: 01-29-2012, 10:05 PM

Tags for this Thread

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