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:
ROUND function rounds the number value to nearest digit mentioned in argument.
ROUND function has two required arguments i.e. number and num_digits
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
Working with huge data is always exciting and challenging. From 2007 version onward, Excel is supporting more than a million rows in each worksheet. One of the common problems with huge data is “Duplicates” and the bigger problem is to identify and remove these duplicates. In this article, we will be sharing 4 ways to delete duplicate records from your data.
SUMIFS function is used to get the “total sum” of values for matching criteria across range. SUMIFS Function has required and optional arguments
COLUMN function is used to get the column reference number of the excel worksheet. COLUMN Function has only one argument.
RIGHT function is used for extracting the “Right Most” characters from the available string in Microsoft excel. Function returns value to new string.