+ Reply to Thread
Results 1 to 4 of 4

Grouping names randomizer

  1. #1
    Registered User
    Join Date
    03-31-2015
    Location
    Illinois
    MS-Off Ver
    7
    Posts
    3

    Grouping names randomizer

    Hello, I am trying to group a list of 100 or so names in to groups of 4 randomly, with the caveat if two names have been grouped together previously they should not be grouped together again. Any ideas on how to approach this? Any code you can share or suggested formulas in excel? I am thinking I will need to write a macro, but not sure how to start. thanks! rps

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Grouping names randomizer

    what does your data look like? can you upload your workbook?
    If someone has helped you then please add to their Reputation

  3. #3
    Registered User
    Join Date
    03-31-2015
    Location
    Illinois
    MS-Off Ver
    7
    Posts
    3

    Re: Grouping names randomizer

    My data is simply a list of about 100 unique names such as "John Smith" or "Jane Doe". I can't upload the actual data as it contains names of employees and would probably be violating some legal/security rule. However, I did generate some sample data that you could use to work with if you were so inclined - see attached. Thanks for any feedback.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-31-2015
    Location
    Illinois
    MS-Off Ver
    7
    Posts
    3

    Re: Grouping names randomizer

    I added an updated ss with some additional examples of what I would be looking for.
    Attached Files Attached Files

+ 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. List Randomizer
    By j_christley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-14-2013, 06:28 PM
  2. [SOLVED] Grouping project names!!!
    By devpp in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-08-2013, 06:20 AM
  3. [SOLVED] Farfetched Question: Grouping/Counting Distinct Names
    By aborg88 in forum Excel General
    Replies: 9
    Last Post: 07-17-2012, 10:38 AM
  4. how can I change the default month names for dates grouping in pivot tables
    By bagullo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-25-2011, 05:24 AM
  5. Randomizer Help
    By MGMRAM in forum Excel General
    Replies: 6
    Last Post: 10-16-2006, 10:42 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