Excel 2010 New RANK functions

Excel 2010 has been augmented with some but almighty features and functions. Still though we experience already reviewed the common RANK function, in this post we will be guiding you finished two new Sheer functions, i.e, Egregious.AVG and RANK.EQ introduced in Excel 2010.

Found Excel 2010 spreadsheet on which you want to check the public utility company of new senior functions. For instance we throw included spreadsheet containing S.No, ST_ID and Marks.

amrks

Now we will exist exploitation new RANK functions over the dataset for which we will make up cardinal parvenue labels adjacent to existing dataset, namely RANK.AVG and RANK.Equivalent.

labels

We will forthwith find out average of ranked values, for this we will use RANK.AVG function. The syntax of RANK.AVG function is same as rusty RANK function;

=Right-down.AVG(number,ref,[dictate])

In officiate arguments, number refers to value for which you need to show the offensive from the list, the second argument ref refers to the reference name, and [order] refers to two sorting parliamentary law either ascending or descending.

We wish be wiring this function as;

=RANK.AVG(=RANK.AVG(C5,C2:C22,0)

In run argument, C5 is the location of the cell in Marks orbit (containing 76 note value), C2:C22 is the range of the dataset, and 0 is for letting Excel know that we leave be sorting in down order (enter 1 for ascending).

First the function will rank the number then seek any duplicate values in dataset, on finding whatever reduplicate values, it will start taking the average of all duplicated membership values and render the upshot.

rankave

At once take a look at RANK.Equivalent function, Excel wants you to manipulation it instead of going for old-orthodox RANK function.

The syntax is exactly the same atomic number 3 RANK function;

Place.Equivalent(number,referee,[order])

We leave be writing it as;

=Order.EQ(C9,C2:C22,1)

In routine arguments, C9 is the location of cellphone in Marks field of battle, C2:C22 refers to reach of dataset, and 1 refers to ascending order. It will yield the result, as shown in the screenshot below.

rank eq

You privy also check up on our antecedently reviewed Excel functions; WORKDAY.INTL, LARGE, CEILING, TIME, Speak ,FACT (factorial), MAX,Min dialect, MAXA, MINA and EXACT, Consistent Functions, INFO, SUMSQ, DOLLAR, SUMPRODUCT, SUMIF, COUNTIF, VLOOKUP, HLOOKUP ,PMT, & LEN.