Look up the RANK function in Excel Help. If you want some more help
here, I would suggest you give some details about how your data is
organised.

Hope this helps.

Pete

On Feb 24, 3:17 am,
wrote:
if we give 20 nuber of students how can i calculate their ranks,means 6
subjects will be there, they have to pass all subjects and i want students
list rank wise