Spreadsheet: 81172d1281436627-randomizing-equation-help-needed-test
Sheet: Test

 |  | Harvey Cross
Final List of Students
 |  | Randomized |  |  |  |  |  | Selection |  | Hayden
[NAME] | 0.2971417293329237 | 0
Fred | 0.4402507786437531 | 0 |  | I wish to randomize only the cells which contain text in column A (from A5-A112)
[NAME] | 0.9142240602988032 | 0 |  | The code behind the button allmost works!!!
Hayden | 0.8058231945463197 | 0 |  | But I don’t want the selection to choose any cell which is blank
 | 0.2009206394055436 | 0 |  | …in this case C9 onwards, but this range will change!
 | 0.4529266018438005 | [NAME] |  | Nor to include anything outside the range A5:A112 e.g. The legend in A2 or anything else between [NAME])
 | 0.4034837079648446 | 0
 | 0.8248229227384469 | 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
 | 0.7972512142872858 | 0
 | 0.01550251543430914 | 0
 | 0.4615310803500511 | 0
 | 0.9080671178522182 | 0
 | 0.3384914266345893 | 0
 | 0.5356279783016105 | 0
 | 0.6137019001163608 | 0
 | 0.3776880427797336 | 0
 | 0.4855951397632643 | 0
 | 0.2411946150186317 | 0
 | 0.983641097982008 | 0
 | 0.550550281301061 | 0
 | 0.1656396577199253 | 0
 | 0.9584054673861921 | Hayden
 | 0.711422199793053 | 0
 | 0.08875116757340962 | 0
 | 0.8365437384558512 | 0
 | 0.907382374914353 | 0
 | 0.6136310338611004 | 0
 | 0.6817105498670832 | 0
 | 0.2906372446244756 | 0
 | 0.5597064569748593 | 0
 | 0.08844095009341313 | 0
 | 0.7898978674103374 | 0
 | 0.7982828369236685 | 0
 | 0.1470684273485956 | 0
 | 0.570351990557372 | 0
 | 0.638226263949992 | 0
 | 0.2314652528718772 | 0
 | 0.4315754547064456 | 0
 | 0.7138676720027206 | 0
 | 0.1057337387191124 | 0
 | 0.622374960402903 | 0
 | 0.5558131169100271 | 0
 | 0.8519481733761998 | 0
 | 0.1943377276579294 | 0
 | 0.8021503285251168 | 0
 | 0.1297034451721606 | 0
 | 0.0288620357891729 | 0
 | 0.6653804854670686 | 0
 | 0.9130747720809906 | 0
 | 0.518663607409052 | 0
 | 0.006615364300094129 | 0
 | 0.1808197912244378 | 0
 | 0.04249661520317871 | 0
 | 0.5705849104181251 | 0
 | 0.9257322164065167 | 0
 | 0.8274243284005678 | 0
 | 0.3456562219762445 | 0
 | 0.9010830286968405 | 0
 | 0.7477518316709215 | 0
 | 0.8820658401202328 | 0
 | 0.9799428208064622 | 0
 | 0.2297701402654875 | 0
 | 0.783874547352511 | 0
 | 0.6432565490110509 | 0
 | 0.6338948375308222 | Fred
 | 0.6925263902049075 | 0
 | 0.5130052023962781 | 0
 | 0.4354197338473664 | 0
 | 0.4685331149857115 | 0
 | 0.6750492746724959 | 0
 | 0.8702535585819318 | 0
 | 0.9715258331518459 | 0
 | 0.5665343842788788 | 0
 | 0.1455150028688017 | 0
 | 0.314170174501512 | 0
 | 0.6766107793490312 | 0
 | 0.2057909868358458 | 0
 | 0.2846087148420542 | 0
 | 0.3535154638141904 | [NAME]
 | 0.08669711916403178 | 0
 | 0.6637343099560851 | 0
 | 0.7459850787114406 | 0
 | 0.5307850250581008 | 0
 | 0.05105809560764074 | 0
 | 0.652883962639718 | 0
 | 0.1847240846708775 | 0
 | 0.3865625526882301 | 0
 | 0.642156951108237 | 0
 | 0.8347438339956388 | 0
 | 0.2305206711684997 | 0
 | 0.1548385458357944 | 0
 | 0.8806856533365299 | 0
 | 0.42512841806042 | 0
 | 0.3975207713849205 | 0
 | 0.2628227713040279 | 0
 | 0.3937639768577017 | 0
 | 0.367343719488425 | 0
 | 0.893996095822275 | 0
 | 0.1469840705629366 | 0
 | 0.7418839986004315 | 0
 | 0.2540772548380241 | 0
 | 0.5040467642349287 | 0
 | 0.454598551234449 | 0
 | 0.8236986735239542 | 0
 | 0.7559996787542538 | 0
 | 0.8841720455263617 | 0
 | 0.6649861143987419 | 0
 | 0.03995651004410039 | 0