Results 1 to 3 of 3

Randomly assign name a specified number of times with criteria

Threaded View

sinspawn56 Randomly assign name a... 11-06-2015, 10:58 AM
sinspawn56 Re: Randomly assign name a... 11-11-2015, 04:58 PM
sinspawn56 Re: Randomly assign name a... 11-20-2015, 03:10 PM
  1. 11-06-2015, 10:58 AM #1
    sinspawn56 is offline
    Forum Contributor
    Join Date
    02-13-2009
    Location
    Indiana
    MS-Off Ver
    Excel 2015
    Posts
    183

    Randomly assign name a specified number of times with criteria

    Hello Excel Forum!

    I have a list of... items. I would like to assign a name to these items at random and for a configurable amount of times. The names that I would like to assign and the items are in specific groups, so I would like only those that are assigned to group one, be assigned to items in group 1.

    The attachment has clearer instructions in cell B2 that explains what I am trying to do. As always I appreciate everyone!

    Random Select Example.xlsx
    Attached Files Attached Files
    Last edited by sinspawn56; 11-11-2015 at 04:50 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Assign players to teams randomly
    By buhaj47 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2015, 05:26 PM
  2. Randomly assign to groups, without duplicates
    By rw2 in forum Excel General
    Replies: 5
    Last Post: 05-08-2015, 08:31 AM
  3. [SOLVED] Randomly assign codes to cells
    By Gemsie in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-29-2013, 12:28 PM
  4. [SOLVED] VBA loop to copy a worksheet a number of times, assign name each time based on loop number
    By TBG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2012, 10:54 PM
  5. Randomly assign a value to rows
    By covegolfer in forum Excel General
    Replies: 3
    Last Post: 06-13-2011, 12:29 PM
  6. Randomly (and evenly) assign colors to cells
    By JChandler22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2010, 05:22 PM
  7. How do I randomly assign values in a grid?
    By Excel question in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2005, 08:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1