Selecting evaluating people using excel

[abhishekesharma]

Hi
I have 100 students in my class and there's an article that I want them to submit. Also I want 5 of the students to evaluate each other's articles. All the students have a unique number. Can someone please suggest a formula for the same?

PS I don't want any student to evaluate his or her own article.
Also each student gets 5 articles to evaluate which are random.

I tried using the if statements and index formula somehow something was missing.

Kindly help. A little confused.

Basically a list of 5 students selected at random in front of a student's name and uniqueID who ll evaluate his or her own article.

Thanks in advace.

 

[seguin85]

	A	B	C	D	E	F
1	Student#	Eval1	Eval2	Eval3	Eval4	Eval5
2	1234
3	5555
4	9999

<tbody>
</tbody>

In B2 enter

=INDEX($A$2:$A$101,RANDBETWEEN(1,100))

and copy this to all cells in B2:F101.

Edit:
This will not prevent them from getting their own number, will work on a fix.