1 rank function. RANK function is a ranking function provided by Excel, but it is based on foreign ranking habits.
2, COUNTIF function. The COUNTIF function can also achieve ranking. According to the characteristics of Excel, when the score is the same, the greater the number of rows, the greater the ranking.
3, SUMPRODUCT function. The SUMPRODUCT function can also achieve ranking.
Knowledge expansion
Calculation is an important part of mathematics and one of the basic skills that people must master in daily life. Calculation not only refers to simple addition, subtraction, multiplication and division, but also includes more complex operations, such as algebra, function, probability, statistics and so on.
Calculation is ubiquitous in our life, from daily shopping bookkeeping, calculating time and distance, to various calculations in scientific experiments, engineering design, economic forecasting and other fields. Calculation is an abstract thinking activity, which requires us to use certain mathematical knowledge and skills to get the correct results through analysis and reasoning.
There are various calculation methods and skills, and different calculation problems need different methods and skills to get correct answers. For example, simple addition, subtraction, multiplication and division problems, we can directly apply formulas to calculate;
For the calculation of algebraic expressions and functions, you need to use certain algebraic knowledge and skills; For the calculation of probability statistics, it is necessary to master the basic principles and methods of probability theory and statistics.
In the field of mathematics, calculation is also a tool to study various mathematical problems. For example, algebra, we can study the solutions of equations and the properties of functions through calculation; In geometry, we can study the nature and area of graphics by calculation; In probability statistics, we can study the law of random phenomena and the distribution of data through calculation.
In addition to its application in mathematics, calculation also plays an important role in other fields. For example, in physics, the laws and properties of various physical phenomena can be studied by calculation; In chemistry, we can study the energy changes of chemical reactions and the properties of chemical bonds by calculation. In economics, we can study the relationship between supply and demand in the market and the growth trend of the economy through calculation.
In a word, calculation is one of the indispensable skills in people's daily life, and it is also a basic tool for studying problems in various scientific fields. Mastering certain calculation skills and methods is of great significance for us to solve practical problems and develop scientific thinking.