Closed Thread
Results 1 to 3 of 3

Random selection from list without repetition

  1. #1
    Registered User
    Join Date
    06-11-2010
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    6

    Random selection from list without repetition

    Hi all,

    What I have is a column of 36 data items (all strings), what I need to do is select groups of 8 data items randomly from the list and copy them into a series of 8 cell ranges, with no repetition in the group and no groups of 8 being identical (for these purposes the same 8 items in a different order counts as identical).

    Any assistance would be much appreciated... Any clarification required, please ask away.

    Cheers

    Matt

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Random selection from list without repetition

    I have a file on my site that demonstrates various methods of selecting unique number of items from a list.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Random selection from list without repetition

    See attached file where I added this macro... it may be an idea.
    Please Login or Register  to view this content.
    Regards,
    Antonio
    Attached Files Attached Files

Closed Thread

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