RANK function has two required argument i.e. number, ref and one optional argument i.e. [order]
number argument is used to give number value for which ranking is required
ref argument is used to give range or list of values from which rank to measure
[order] is optional argument and Value 0 or 1 can be given as per below requirements:
[order] = 0 or omitted: Highest value will be Ranked as 1st position (example: Value 5=Rank1, 4=Rank2, 3=Rank3, 2=Rank4, 1=Rank5 and so on)
[order] = 1: Lowest value will be Ranked as 1st position (example: Value 1=Rank1, 2=Rank2, 3=Rank3, 4=Rank4, 5=Rank5 and so on)
Example 2: RANK function with [order = 1] (Lowest value is ranked first)
Example 3: RANK function with [order = 1] (Lowest value is ranked first) with Repeat values
If list of values or ref argument has duplicate values, ranking for those values will be same across
Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.
This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.
So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.
We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion
This course is going to help you to excel your skills in Excel VBA with our real time case studies.
Lets get connected and start learning now. Click here to Enroll.
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
If you liked this article and want to learn more similar tricks, please Subscribe us or follow us on Social Media by clicking below buttons:
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.
AVERAGEIFS function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.
WEEKDAY function applies to a Date and returns the output for Day of the week. The output of the function varies from 0 to 7
LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.
SUMIFS function is used to get the “total sum” of values for matching criteria across range. SUMIFS Function has required and optional arguments
Have you ever got into situation in office where you need to count the cells in Excel sheet with specific color? If yes then you can use following code which counts the number of cells…