Pivot Table Report – Grouping the Date Field by Days, Months, Quarters and Years in Microsoft Excel 2010

If you want to find the minimum value based on the criteria in a range,you can use MIN & IF functions to retrieve the output.

Min: Returns the smallest 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 5.

Syntax =MIN(number1,number2,…)

number1:These are numeric values.They can be numbers, name ranges or arrays. It is the first value argument that represents the values that you have taken as a reference.

number2:These are numeric values.They can be numbers, name ranges or arrays. It is the second value argument that represents the values that you have taken as a reference.

There can be a maximum 255 arguments.Refer below shown screenshot:
style=”font-size:16px;”

The IF function checks if a condition you specify is TRUE or FALSE. If the condition returns TRUE then it returns preset value, and if the condition returns FALSE then it returns another preset value.

Syntax = IF(logical_test,value_if_true,value_if_false)

logical_test: Logical test will test the condition or criteria.If condition meets then it returns the preset value, and if condition does not meet then it returnsanother preset value.

value_if_true: The value that you want to be returned if this argument returns TRUE.

value_if_false: The value that you want to be returned if this argument returns FALSE

Let us take an example:-

We have some codes in column A & numbers in column B.Condition is set in cell D2 & D3.We want a formula that will give the minimum value from column B based on the criteria set in cell D2 & D3.

• In cell E2, the formula would be
• {=MIN(IF(\$A\$2:\$A\$9=D2,\$B\$2:\$B\$9))}
• This is an array formula which requires formula to be enclosed with curly brackets by using CTRL + SHIFT + ENTER.

• Copying the formula in cell E3, we will get the minimum output for code BBB

Terms and Conditions of use

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.