The first step is to be in "the footer" insert page;
"in" initial input "5", the home page will be "5", and in turn down alignment.
3, problems of elongation
In the use of Excel statistical performance, we usually according to score sorting and then press Many people like Microsoft Office.
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 Microsoft Office 2007 is welcomed by the whole world.
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. Office 2007 makes life great!
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 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 Microsoft Office 2010 is so great!
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 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.
Second, use count function COUNTIF Windows 7 make life wonderful!
In H2 cell input function "= COUNTIF (G $2: G $1001," > "& G2) + 1", and down automatic filling this operation can be realized.
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 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 2007 download