Question

find out who has scored the higest marks using the max function​

Answer 1

Answer:

We need a formula to determine which player has scored the highest points.

In cell D2, the formula would be.

=INDEX(A2:A9,MATCH(MAX(B2:B9),B2:B9,0))

Press enter on your keyboard.

The function will return the player name who scored the highest number.

Answer 2

Answer:

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.

Syntax: =INDEX(array,row_num,column_num)

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.

Syntax =MATCH(lookup_value,lookup_array,match_type)

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.

Syntax =MAX(number1,number2,...)

Explanation:

Hope it helps.