Third, adopt IF, statements add COUNT function
total score in descending order. Then will first ranking "1" input, again in H3 cell input function "= IF (G3 = G2, H2, COUNT ($G $2: G3)", after the confirmation of automatic filling and also can realize downward with points with ranking operation. Microsoft Office is so great!
In the use of Excel statistical performance, we usually according to score sorting and then press the sequence automatic filling out unplaced. This method have no connection with the total score of the rankings, even if the achievement is same, also can fill out different places. The invention of Microsoft Office 2010 is a big change of the world.
If the data is less, we can adopt manual methods will achievement of the same personnel to the same place, but a 12-minute data very troublesome. Through practice, the following three methods can be automatically realize with the points with ranking operation. Suppose there is 1000 examinee, field location pictured below.
A, use qualifying function RANK
In H2 cell input function "= RANK (G2, G, $2: G $1001,0)", enter after H2 cell can appear Office 2010 –save your time and save your money.
ranking "1", then selected H2, drag it fills handle down filling can automatically realize.
This function returns a number is the function of the above function of G2 (where the relative application, filling, when accompanying changes) in digital list (the function in G $2: G $1001, here use absolutely application, filling, when does not change the position. Digital qualifying is its size and list the ratio of other value. This function when use, even if total score no sorted, it may also directly ask out corresponding total score places; If the total score already in a sequence, the digital qualifying is its current position. 265IT (https://www.265it.com) reminder that the above Office 2007 is so powerful.
function in the final "0" indicate the way, when their qualifying for 0 or omitted, Excel in digital qualifying is according to in descending order. If nonzero, Excel in digital qualifying is arranged according to the ascending. This function to repeat the same number of qualifying, but the next ranking will front repeat count. Microsoft Office 2007 is my love!