Excel Formulas to Find the Position of Maximum Value From the List!!

Sometimes you may need to find out the position of the maximum value in Excel. How do you deal with Excel? This article provides some simple formulas to help you quickly get it done. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

• Use the below formula to get the position of the maximum value from the range.

=MATCH(MAX(range),range,0)

Syntax Explanations:

• MATCH – In Excel, the MATCH function will help to locate the position of a lookup value in a row, column, or table.
• MAX – This function will return the largest numeric value from the range of input values. Read more on the MAX function.
• Range – It represents the input data from your worksheet.
• Comma symbol (,) – It is a separator that helps to separate a list of values.
• Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example to get the position of max value.

• First, we will enter the input values in Column B and Column C.

• Then apply the given formula to theformula bar section and press Enter key.

• Finally, we will get the results in the selected cell.

Closure:

In this short tutorial, you can get some clarification on how to find the position of the maximum value from a range in Excel. Hope this helps you. Leave a comment or reply below – let me know what you think! Click here to know more about Geek Excel and Excel Formulas!!

Read Ahead:

• Excel Formulas to Find the Maximum Value from a Set of Numbers!!
• Excel Formulas to Find the Maximum Value of Every Nth Column!!
• Find Position of Nth Occurrence of a Character in Text String in Excel!!
• Excel Formulas to Find the Partial Match Against the Number!!