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:
INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.
MOD function is used to get the remainder of number that is divided by divisor. MOD Function has two required arguments i.e. number and divisor.
SUBSTITUTE function is used to substitute the existing old text to new text.
https://youtu.be/HmJL_y93pAs WEEKNUM function helps to calculate the week number of the given date in a year. It considers 1st January as first week by default and through the output for the given input date. Syntax:…
FIND function is used to find the position of text, or character in an available string.
LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.