Calculating positions in class

[[email protected]]

Good day all,

Please if I have these avaerage scores for my students and want to determine first, second, third.... positions, what formular do I use?

Emeka 80
Chima 50
Ngozi 75
Chibuike 65
Nneka 95

Thanks

[dogberry]

Hi

Can you post a sample worksheet.

Thanks

Chris

[Fotis1991]

As i understand your query, LARGE function for the numbers and then INDEX& MATCH for the Names.

[[email protected]]

Honestly I have forgotten how to attach a file here. Please help.

[Norie]

You could use the RANK function.

Assuming names in A1:A5 and average scores in B1:B5:

=RANK(B1,$B$1:$B$5)

[FDibbins]

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[[email protected]]

Thanks a lot. I got it but I want the answers to be in "first", "second"... order instead of 1,2,3...

[shg]

=choose(rank(B1, $B$1:$B$5), "first", "second", third", "fourth", "fifth")

[Norie]

Do you mean you want the formula to return 'first', 'second' etc?

Or do you want to rearrange the positions of the students?

[[email protected]]

Yes Norie. That's what I mean. Thanks.

[Norie]

Then the formula shg posted should do that for you.

[[email protected]]

Yes it worked but I think I will have to type the positions manually. Is there no way excel can pick subsequent positions after I have typed "first" and "second" positions into the formular?

[Norie]

Excel won't automatically return 'first', 'second' etc.

There are formulas that will turn 1,2,3 etc into 1st, 2nd 3rd etc.

Would that be acceptable?

[[email protected]]

Yes I will appreciate any formular that can do the work. Thanks greatly