In this article we will learn how we can retrieve the player who scored the highest number of points in Microsoft Excel 2010.
To retrieve the name of the player who scored the highest number of points, we will use a combination of INDEX, MATCH & MAX functions to get the output.
INDEX: Returns a value or reference of the cell at the intersection of a particular row and column, in a given range.
MATCH function searches for a specified item in a selected range of cells, and then returns the relative position of that item in the range.
MAX: Returns the maximum number from a range of cells or array. For example,if a list of numbers contains 5, 6, 7, 8, 9 & 10, then the output will be 10.
There can be maximum 255 arguments. Refer below shown screenshot:
Let us take an example:
We have number of players in column A & the points scored by them in column B. We need a formula to determine which player has scored the highest points.
In this way, if we have a similar requirement, then we can achieve it by using INDEX, MATCH & MAX functions together.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.