random assigned set values for elimination draft

[jonnyboy26]

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

[Kaper]

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

[jonnyboy26]

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.

[Kaper]

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.