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
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:
AVERAGEIF function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.
Excel Function DATE While using Microsoft Excel, you must have got the situation where you need to use the Date function. Date function is one of the common and most used function in Excel that…
Excel Function REPLACE REPLACE function is used to replace the existing text from a specific location in a cell to New Text. REPLACE Function has argument four arguments i.e. old_text, start_num, num_chars and new_text. We need to give the…
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.
CONCATENATE function is used for combining two or more Microsoft Excel strings into one. The output of the function returns as a combined string in new cell.
INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.