Second, use count function COUNTIF
automatic filling this operation can be realized. I love Office 2010 !
This function is the function of calculated regional satisfies given conditions in the cell number. The above function use absolutely quoted designated calculated regional G $2: G $1001, ranking of the corresponding cell G2 use relative references. Namely ask out in the G2: G1001 area more Microsoft outlook 2010 is convenient!
than unplaced corresponding total score the number of cells, then adds 1 can be concluded that the cell numerical places. This operation whether there are several repeated, greater than its number is fixed, so repeating data ranking is also the same. With the same RANK function, this function has no matter whether by sorting all can score above operation. Office 2010 key is for you now!
Third, adopt IF, statements add COUNT function
This operation with these two different approaches, must be in accordance with the 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.
In the use of Excel statistical performance, we usually according to score sorting and then press Office 2010 download is available now!
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.
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 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 Microsoft Office 2007 is the best invention in the world.
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 function in the final "0" indicate the way, when their qualifying for 0 or omitted, Excel in digital Outlook 2010 is powerful.
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.