Excel Made Easy

Get percentile rank for students in Excel

To do it in Excel, here is the answer:

a) Enter the formula =PERCENTRANK($D$3:$D$22,D3,2) in "Percentile Rank" column for first student. Drag the formula all the way down to end of column.

The first argument in formula corresponds to the array containing the scores, the second argument corresponds to individual Student score and the 3rd argument define the number of significant digits in the result.

You can find similar Excel Questions and Answer hereunder

1) I want to add a trend indicator symbol next to my sales data - how can I do that?

2) How do I get the rank of a number in a list of numbers?

3) Keyboard shortcut for save as in Excel

4) I have to determine bonus for my staff based on ratings (for each rating, specific bonus amount). In Excel, how can I set up my Bonus Table?

5) Is there a way to get a log value of a number using Excel?

6) I am using Excel for Project Management - how can I find End Date for a task given Start Date and Task duration considering only working days?

7) How can I clear cell after activating a routine when there is a change in value of a cell?

8) How can I get the information about my current operating environment (OS version, Excel version, Current Directory)

9) How do I get the principal part of loan payment for a period given Loan amount, Rate of Interest and period?

10) How can I get the most frequently occurring text in a range?