Return First or Last Date (Earliest or Most Recent) Excel Formula | Based on Multiple Criteria

Описание к видео Return First or Last Date (Earliest or Most Recent) Excel Formula | Based on Multiple Criteria

Download the featured file here: https://www.bluepecantraining.com/wp-...

In this video I demonstrate how to lookup and return the earliest or most recent date . To do this without criteria use the MIN or MAX functions. To achieve this using single or multiple criteria use the MAXIFS function.

Table of Contents:

00:00 - Introduction
00:17 - Return the earliest or most recent date using MAX and MIN
02:58 - Return the earliest or most recent date based on a single or multiple criteria using MAXIFS
05:47 - Using Excel tables
------------------------

Комментарии

Информация по комментариям в разработке