MINIFS function
Excel » Functions » Statistical » MINIFS function »
How to find the smallest number excluding zeros
Column B contains numbers, the formula in cell D3 calculates the smallest value excluding zeros. Note that all numbers are […]
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 ignore duplicates
This article demonstrates ways to sort numbers from smallest to largest ignoring duplicate numbers. Table of Contents SMALL function with […]
Compare two columns in different worksheets
This article describes an array formula that compares values from two different columns in two worksheets twice and returns a […]
Find and return the highest number and corresponding date based on a condition
This article describes how to filter records based on the maximum value of a specific item. There are names in […]
Get the smallest number larger than a given number
This article demonstrates how to extract the smallest number larger than a condition and the largest number smaller than a […]
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 […]