I can optimize this formula very quickly, no form, bottom of list. Same order as original list order, just move them to the bottom of the list.Brandon Deem said:Don't return the form, number of entries / alphabetical. 5 entries Z beats, 4 entry A. Highest dollar prize.
Wait, let me see if I understand this correctly. If a shooter has 20 entries, they have 20 chances to be picked for the first prize correct?Wall said:We've randomized the list of entries & will randomly select the winning first pick.
The pick order will simply flow down the list from there.
Yes. They're name is in the list as many times as they have entries. Once their name comes up they're remaining entries are ignored.E.Swisher said:Wait, let me see if I understand this correctly. If a shooter has 20 entries, they have 20 chances to be picked for the first prize correct?
If that shooter is not chosen first, shouldn't they have 20 chances for the 2nd prize?
Got it, thanks!Wall said:There're 1955 (IIRC) entries on the list, randomized.
We'll select pick #1 & the list flows down from there.
Yea that would be a lot easier.Jeff T said:I can optimize this formula very quickly, no form, bottom of list. Same order as original list order, just move them to the bottom of the list.
Live Simply, Love Generously, Care Deeply, Speak Kindly, Shoot Well, Leave the Rest to God.
Not that I care either way, but it would reward the people who actually follow or participate in this great forum. You snooze you lose.Brandon Deem said:Yea that would be a lot easier.
Dick, that's why I told you to look at itBurk Cornelius said:Something is ****y. Have you ever noticed how many "lawmonkey"s we have?
Sent from my Samsung Galaxy S5 using Tapatalk 5.3