How to make the elimination table with Excel?

1. Create a new worksheet and name it Scoring Table. Set the title according to the format shown below. Cell A 1 is the player number and cell B 1 is the judge 1. Complete the data from Judge 2 to Judge 10 through automatic filling, B 1: K 1. Enter the average score in L 1 and the ranking in M 1.

2. Enter "player 1" in A2, put the mouse on the "ten" in the lower right corner of the selected A2 cell (that is, fill handle), hold down the left mouse button and drag it down to A 1 1, so as to quickly enter the number of the contestants. The more players, the more obvious the advantages of this automatic filling method.

3. Enter the formula "= (sum (b2: k2)-max (b2: k2)-min (b2: k2))/8" in the L2 cell, which means to find the total score 10, then subtract the highest and lowest scores of the judges and divide by 8; The result of the calculation is 0, because there is no score before. Then use the auto-fill function to copy the average scores of other players.

4. Enter the formula "= rank (L2, $ L $2: $ L $ 1 1)" in m2. The function of this formula is to calculate the sorting of cell data in the whole data area. For example, the above formula is used to calculate the ranking of L2 L2 cell data: L 1 1. Please pay attention. There is no mistake in copying the following formula. There is no data yet. As you can see, the ranking of all the players is 1.

5. Input the corresponding data in the judges' scoring column, and the average score and ranking can be automatically calculated. Enter the data of a player first, and the average score of the first player has been automatically calculated.

6. Next, enter the data of other players. You see, the average score is automatically calculated, and the ranking is also automatically entered and exited.