I run a Fantasy Sports League, and am looking for a formula to give me the draft order results. There are four slots, and they have a 44%-24%-18%-14% assigned to them. Is there a formula I can use so that it will spit out an order based on those four percentages? i.e. 1st-3rd-2nd-4th or 2nd-4th-1st-3rd? I do have a column with names that fills to those percentages with the specific finish from whichever season is appropriate i.e. Bob at 44 entries, Tom at 24 entries, etc. Is there something I can use? Currently I have INDEX($A$3:$A$102,RANDBETWEEN(1,ROWS($A$3:$A$102)),1)
but that just gives me a random from that section, and can spit out multiples of the same.
Bookmarks