+ Reply to Thread
Results 1 to 5 of 5

Random Generator with multiple parameters

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

    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
    Registered User
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016
    Posts
    201

    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.
    How to learn VBA: RECORD A MACRO ... and study it!

  3. #3
    Valued Forum Contributor
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    809

    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
    91

    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
    Registered User
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016
    Posts
    201

    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

+ Reply to 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