# How To Find The Position Of The Minimum

## Example

=MATCH(MIN(B3:B10),B3:B10,0)

## Generic Formula

=MATCH(MIN(Range),Range,0)

Range – This the range of values in which you would like to find the relative position of the minimum value.

## What It Does

This formula will return the relative position of the minimum value in a given range of numerical values. The formula will work for any one dimensional vertical or horizontal range. If the range contains multiple minimums, then the formula will return the position of the top most or left most minimum.

## How It Works

This formula uses the MIN function to first find the value of the minimum within the given range, then it uses the MATCH function to find the relative position of this minimum within the range.

In our example MIN(Range) returns the value 0 since 0 is the minimum value in the range of values {1;0;8;6;9;7;9;6}.

MATCH(0,Range,0) looks for a 0 in the Range and will return the position of the first 0 it finds. The 0 at the end of the formula is a predefined Excel parameter that tells the MATCH function to find an exact match in the Range. In our example MATCH(0,{1;0;8;6;9;7;9;6},0) returns the value 2 since the first 0 in {1;0;8;6;9;7;9;6} is in the 2nd position.

## John MacDougall

John is a Microsoft MVP and freelance consultant and trainer specializing in Excel, Power BI, Power Automate, Power Apps and SharePoint. You can find other interesting articles from John on his blog or YouTube channel.

## Related Articles

#### How To Conditionally Concatenate A Range

This formula will conditionally concatenate a range based on a criteria in another range.

#### How To Solve a Quadratic Equation

These formulas will give the solutions to a quadratic equation.

#### How To Select A Random Item From A List

This formula will return a random selection from a given list with each item in the list having an equal probability of being selected.