# How To Do No Duplicates - Almost There!

1. ## How To Do No Duplicates - Almost There!

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.

2. ## Re: How To Do No Duplicates - Almost There!

Try the following:
Formula:
`Please Login or Register  to view this content.`

Let us know if you have any questions.

3. ## Re: How To Do No Duplicates - Almost There!

Thank you for your help! That seems to be working as we need! You are a lifesaver!

4. ## Re: How To Do No Duplicates - Almost There!

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

There are currently 1 users browsing this thread. (0 members and 1 guests)