Spreadsheet: 81361d1281563127-randomizing-equation-help-needed-pickonstudent
Sheet: Test

 |  | Harvey Cross
Final List of Students
 |  | Randomized | previous |  |  |  |  | Selection |  | [NAME]
[NAME] | 0.2192154740360079 | 0 | x
Fred | 0.5599817847278414 | 0 | x | I wish to randomize only the cells which contain text in column A (from A5-A112)
[NAME] | 0.06139272254009054 | 0 | x | The code behind the button allmost works!!!
Hayden | 0.5066801165960388 | 0 |  | But I don’t want the selection to choose any cell which is blank
[NAME] | 0.5452950810458956 | 0 | x | …in this case C9 onwards, but this range will change!
[NAME] | 0.4907436823270876 | 0 | x | Nor to include anything outside the range A5:A112 e.g. The legend in A2 or anything else between [NAME])
[NAME] | 0.1260525816496907 | 0 | x
Mark | 0.345802963289974 | 0 |  | Therefore, for each Button Press, we would generate a random selection from only the visible selection in column A exlcuding headings etc in the region A5:A112
[NAME] | 0.8711393927953797 | 0
[NAME] | 0.5703135121613023 | [NAME] | x
[NAME] | 0.01451333852332404 | 0 | x
[NAME] | 0.7602797304187485 | 0
[NAME] | 0.8945198045555331 | 0
[NAME] | 0.3709899883099572 | 0 | x
[NAME] | 0.05138759366011403 | 0 | x
[NAME] | 0.9552980382216827 | 0
Bo | 0.3673038987815893 | [NAME] | x
 | 0.7072072719079951 | 0
 | 0.1981261374801913 | 0
 | 0.66633764086128 | 0
 | 0.560794444774678 | [NAME]
 | 0.8381073252315483 | 0
 | 0.8881893791474273 | 0
 | 0.5176677267358585 | 0
 | 0.4337508779993566 | 0
 | 0.5870319297929427 | 0
 | 0.6271725884233605 | 0
 | 0.07626595243930989 | 0
 | 0.9878311649134102 | [NAME]
 | 0.4712472698135057 | 0
 | 0.4269392249660426 | 0
 | 0.3684280770919504 | 0
 | 0.6863144409715849 | 0
 | 0.3381453968580619 | 0
 | 0.6040784980461176 | 0
 | 0.332345598814709 | 0
 | 0.9719005360074302 | 0
 | 0.9341437085607585 | 0
 | 0.1852154673035793 | 0
 | 0.5417598412813156 | 0
 | 0.83535232620524 | 0
 | 0.4856218043836078 | 0
 | 0.3717589987700247 | [NAME]
 | 0.9843598134516318 | 0
 | 0.9839008929492934 | Fred
 | 0.3833236101745872 | [NAME]
 | 0.2708498717276115 | 0
 | 0.5319726025622684 | 0
 | 0.5392859339646803 | 0
 | 0.3908952281536646 | 0
 | 0.8215795004176831 | 0
 | 0.9249336341140904 | 0
 | 0.8214969801962813 | Hayden
 | 0.9903187594571281 | [NAME]
 | 0.7411675327565348 | 0
 | 0.3290005371560298 | 0
 | 0.126894598897171 | 0
 | 0.2676611290654813 | 0
 | 0.952668465291941 | 0
 | 0.2245591701326108 | 0
 | 0.9585500684349919 | 0
 | 0.2786490185817607 | 0
 | 0.5226975119589381 | 0
 | 0.2332823131164266 | 0
 | 0.2674672702692349 | 0
 | 0.3987169094407932 | 0
 | 0.3675534374565936 | [NAME]
 | 0.002457348518044356 | 0
 | 0.02450381770544396 | 0
 | 0.02260783834011004 | Bo
 | 0.9933739536735997 | 0
 | 0.7212774545048841 | Mark
 | 0.6954290337710098 | 0
 | 0.2019977498859626 | 0
 | 0.2342670494338641 | 0
 | 0.3294856489973848 | 0
 | 0.6036777263040056 | 0
 | 0.1273581666678183 | 0
 | 0.876582552006731 | 0
 | 0.6755569338834206 | 0
 | 0.2203819870740329 | 0
 | 0.3334349881469425 | 0
 | 0.917367758965085 | 0
 | 0.535928929661803 | 0
 | 0.3413006061800781 | 0
 | 0.8533591790739665 | 0
 | 0.1211835688554663 | 0
 | 0.9837684060756624 | 0
 | 0.2093564874502436 | 0
 | 0.2669564450687751 | 0
 | 0.8037993905130731 | 0
 | 0.8724773914853401 | [NAME]
 | 0.3293173793031361 | 0
 | 0.3107406678748736 | 0
 | 0.9083732816932004 | 0
 | 0.907623897010903 | 0
 | 0.3469632467696588 | 0
 | 0.2635356995422296 | 0
 | 0.5717751508716473 | [NAME]
 | 0.4029380968104181 | 0
 | 0.3900060891257229 | 0
 | 0.7661493720907313 | [NAME]
 | 0.3071946771045921 | [NAME]
 | 0.9582987199007649 | 0
 | 0.3820913824616319 | 0
 | 0.5997527745763724 | [NAME]
 | 0.009759897903148573 | 0
 | 0.4600545701077827 | 0