Need help in Excel

[cendyne]

I have 30 usernames in the first column. There are fifteen columns (scores) for fifteen assignments. From those 15 columns, I need to select the top 10 (scores) for each user and average them. Does anyone know how to do this in excel.

UID Score1 Score2 ........Score15 Avg
xxx 2 3 2

 

[Anubis]

i used to. try google cause that where i foun dhoyw to do a non repeating random number generator

 

[MainFramed]

GOOGLE