Second, use count function COUNTIF
In H2 cell input function "= COUNTIF (G $2: G $1001," > "& G2) + 1", and down automatic filling this operation can be realized. Microsoft Office 2010 is the best software in the world.
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 Office 2010 is powerful!
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.
Third, adopt IF, statements add COUNT function Microsoft Office 2007 can give you more convenient life.
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.
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 Office 2007 key is very convenient!
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