+ Reply to Thread
Results 1 to 6 of 6

Random Generator with multiple parameters

  1. #1
    Registered User
    Join Date
    12-12-2013
    Location
    Wisconsin
    MS-Off Ver
    Excel 2010
    Posts
    92

    Random Generator with multiple parameters

    I'm working on a project management tool to select a group of people based on a provided ranking (attributes). I'm looking for random results with the maximum attribute factor being 70, and a possible option to request a person be more selected within the results (desirability %). There is a possibility of the max attribute changing and is referenced in Cell G1. Looking to have the random sample of information from the list of eligible employees columns A-D and display the list based on position in columns I through R.

    I am okay with VBA, but haven't dabbled in any random generation and any help would be appreciated. I know enough to be dangerous, but I couldn't find any code where I could start something. I have attached a sample workbook to work with.

    Let me know if you have any questions, and thank you for the help.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    833

    Re: Random Generator with multiple parameters

    maybe these worksheet functions can help you:
    Please Login or Register  to view this content.
    Cheers
    Erwin
    Last edited by Eastw00d; 03-27-2020 at 12:28 AM.
    I started learning VBA because I was lazy ...
    Still developing.... being more lazy...

  3. #3
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,302

    Re: Random Generator with multiple parameters

    The attached may be helpful.
    Generates random pairings.
    No duplicates in groups of 14.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    12-12-2013
    Location
    Wisconsin
    MS-Off Ver
    Excel 2010
    Posts
    92

    Re: Random Generator with multiple parameters

    This is useful, and I may be able to use it with something else I am working on. I don't see a section within the document where I would be able to add parameters. Any thoughts?

  5. #5
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    833

    Re: Random Generator with multiple parameters

    I build this further by using the code of Torachan, but I have not found a solution for the desirability selection.
    Also I had to make a choice in column P, one of the two.....

    Cheers
    Erwin
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    12-12-2013
    Location
    Wisconsin
    MS-Off Ver
    Excel 2010
    Posts
    92

    Re: Random Generator with multiple parameters

    I can work with this. Thank you so much for your help.

+ 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. Random generator 1-36
    By louis128 in forum Excel General
    Replies: 6
    Last Post: 03-06-2019, 07:49 AM
  2. Replies: 6
    Last Post: 02-20-2019, 12:47 AM
  3. random number generator with specific parameters
    By fear_campaign in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-21-2014, 11:28 AM
  4. Replies: 5
    Last Post: 06-21-2013, 10:40 AM
  5. Random Name Generator
    By jsbryan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-13-2012, 10:44 AM
  6. VBA for random generator
    By arn2025 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2012, 06:45 PM
  7. Random Generator
    By taichi56 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-22-2008, 05:05 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