'MAXIFS function' category

How to use the MAXIFS function
What is the MAXIFS function? The MAXIFS function returns the largest number based on a condition or criteria. The MAXIFS […]
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 […]
Find the most recent date that meets a particular condition
This article demonstrates how to return the latest date based on a condition using formulas or a Pivot Table. The […]
Lookup the nearest date
Table of Contents Lookup the nearest date Lookup min max values within a date range 1. Lookup the nearest date […]
Find the smallest number in a list that is larger than a given number
This article demonstrates formulas that lets you extract the smallest number larger than a given number. The example above specifies […]

Excel categories