I have three columns which I am running an equation on to generate a random selection. The first column (B3:B18) is the names of those requesting a class, the second (C3:C18) is a column with randomly generated numbers, and the third (D3:D18) ranks the requestors as either 0,1, or 2. The following formula will randomly select a name from the list.
=IF(ISNUMBER(MATCH(Requesters!G3,GISTeam,0)),Requesters!G3,(IFERROR(INDEX(Class2,LARGE(IF(Requesters!I3:I18="0",ROW(G$3:G$18)-ROW(G$3)+1),INT(RAND()*COUNTIF(G$3:G$18,"0")+1))),(INDEX(Class2,LARGE(IF(Requesters!I3:I18="1",ROW(G$3:G$18)-ROW(G$3)+1),INT(RAND()*COUNTIF(G$3:G$18,"0")+1)))))))
This formula is working as it should, but I have one problem. I don't want it to generate duplicate values. If I use this formula: =INDEX(Class1,RANK(Requesters!C3,Requesters!C$3:C$18)), I can get it to generate unique values, but I can't figure out how to combine the two together.
Thank you for your help! I have attached the file.
Bookmarks