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]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Student#[/TD]
[TD]Eval1[/TD]
[TD]Eval2[/TD]
[TD]Eval3[/TD]
[TD]Eval4[/TD]
[TD]Eval5[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1234[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]5555[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]9999[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.