MINIFS function
Excel ยป Functions ยป Statistical ยป MINIFS function ยป
How to use the MINIFS function
The MINIFS function calculates the smallest value based on a given set of criteria. Formula in cell E3: =MINIFS(C3:C10,B3:B10,"A") The [โฆ]
SMALL function with duplicates
The formulas in column E, shown in the picture above, extracts the k-th smallest value from B3:B9 ignoring the duplicate numbers. [โฆ]
Lookup min max values within a date range
This article explains how to find the smallest and largest value using two conditions. In this case they are date [โฆ]
Find the smallest value in a list that is larger than a number
Problem: Find the smallest value in a list but it has to be bigger than 45? Answer: MINIFS function [Excel [โฆ]
English
Spanish
