Home

Trying to help out a non-profit with booth lottery

%3CLINGO-SUB%20id%3D%22lingo-sub-892776%22%20slang%3D%22en-US%22%3ETrying%20to%20help%20out%20a%20non-profit%20with%20booth%20lottery%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-892776%22%20slang%3D%22en-US%22%3E%3CP%3EUsing%20some%20priority%20rankings%20and%20the%20%3DRAND()%20function%2C%20I%20have%20successfully%20created%20a%20lottery%20to%20give%20preference%20for%20different%20troops%20to%20be%20get%20their%20first%20choice%20at%20booths%20to%20raise%20money%20for%20a%20non-profit.%26nbsp%3B%20Each%20troop%20has%20a%20booth%20preferences%2C%20for%20example%2050%20would%20be%20location%20B%20time%20slot%2010%2C%20which%20they%20ranked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20struggling%20to%20assign%2Fmatch%20the%201st%20troop%20their%201st%20preference%20and%20then%20remove%20that%20option%20from%20the%20pool%20so%20that%20the%202nd%20in%20line%20in%20the%20lottery%20can't%20be%20assigned%20that%20location%2Ftime%20but%20would%20get%20the%20top%20preference%20if%20not%20already%20taken.%26nbsp%3B%20In%20the%20spreadsheet%20attached%20I%20have%2010%20troops%20which%20are%20ranked%26nbsp%3B(column%20G)%20randomly%20to%20be%20assigned%20first%20round%20of%20preferred%20booth%20assignments%2C%20which%20I%20am%20trying%20to%20put%20into%20column%20H%20based%20on%20each%20troops%20top%2025%20preferences%20in%20columns%20I%3AAG.%26nbsp%3B%20Note%20that%20the%20troops%20many%20rank%20%26lt%3B%20locations%2Ftimes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-892776%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
staraman
Occasional Visitor

Using some priority rankings and the =RAND() function, I have successfully created a lottery to give preference for different troops to be get their first choice at booths to raise money for a non-profit.  Each troop has a booth preferences, for example 50 would be location B time slot 10, which they ranked.

 

I am struggling to assign/match the 1st troop their 1st preference and then remove that option from the pool so that the 2nd in line in the lottery can't be assigned that location/time but would get the top preference if not already taken.  In the spreadsheet attached I have 10 troops which are ranked (column G) randomly to be assigned first round of preferred booth assignments, which I am trying to put into column H based on each troops top 25 preferences in columns I:AG.  Note that the troops many rank < locations/times.

 

Thanks in advance.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies