+ Reply to Thread
Results 1 to 4 of 4

random assigned set values for elimination draft

  1. #1
    Registered User
    Join Date
    01-25-2016
    Location
    guelph
    MS-Off Ver
    2013
    Posts
    3

    random assigned set values for elimination draft

    I am trying to build a program which has a list from 0-999 (defined as draftnumbers), that will have 7 people randomly assigned each of those values. as the draft progresses it needs to reassign the numbers of the person eliminated until the last person has 100% chance of winning. each person does not have same chance of winning it must differ because how how the placed in the season.

    I can not figure out how to randomly assign the values without rearranging the list itself. preferable it just show up as a highlighted colour who owns the number then pop up the winner after i type in all 3 digits.

    I expect many of headaches trying to figure this out with me and i really do appreciate any suggestions and answers.

    thanks

    Jon

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,879

    Re: random assigned set values for elimination draft

    headache is probably a good keyword :-P

    But to be more helpfull. What we shall probably start with is sample file, so please consider attaching a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet (do it for few steps) in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    01-25-2016
    Location
    guelph
    MS-Off Ver
    2013
    Posts
    3

    Re: random assigned set values for elimination draft

    savich cup.xlsx
    still learning this forum it's day 2 on it. good to know i can just drop a sample of work to help people understand what i am making mess of.

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,879

    Re: random assigned set values for elimination draft

    A step forward :-)

    I assume we now see what I named above as "a BEFORE sheet". Probably we miss players names in it.

    Would be needed to proceed, to see "an AFTER sheet" the best - after first graw, then next snapshot after second draw etc.

+ 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. [SOLVED] Array not storing values that I've assigned to it.
    By EverGreen1231 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2016, 11:14 AM
  2. [SOLVED] Random assigned teams with multiple criteria
    By mst3kr in forum Excel General
    Replies: 12
    Last Post: 04-29-2015, 02:03 PM
  3. Random Numbers assigned to static values multiple times no duplicates....?
    By rhattala in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-24-2014, 09:40 PM
  4. Replies: 3
    Last Post: 09-30-2012, 03:03 PM
  5. Summing up assigned values
    By ncguy in forum Excel General
    Replies: 2
    Last Post: 08-17-2010, 04:42 PM
  6. Random numbers plus assigned number
    By mutchdea in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-28-2009, 09:57 PM
  7. add Alphabets who are assigned values.
    By all4excel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-26-2007, 10:28 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