In this video, we use an Excel formula to lookup the most recent date in the past based on criteria. Our example is to return the date of the most recent class, specified by a cell value.

This is an intriguing challenge which came about from a question on one of my other videos.

It utilises a couple of helper columns with formulas before we use an INDEX and MATCH formula combination to return the date.

Find more great free tutorials at;
[ Ссылка ]

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► [ Ссылка ]
Excel VBA for Beginners ► [ Ссылка ]
Advanced Excel Tricks ► [ Ссылка ]
Excel Formulas Made Easy ► [ Ссылка ]
Creating Sports League Tables and Tournaments in Excel ► [ Ссылка ]

Connect with us!

LinkedIn ► [ Ссылка ]
Instagram ► [ Ссылка ]
Twitter ► [ Ссылка ]

свернуть