Lookup the Most Recent Past Date Based on Criteria Excel Formula

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=IYkX99NtdXY

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; • https://www.computergaga.com • ** Online Excel Courses ** • The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel • Excel VBA for Beginners ► http://bit.ly/2JvnnRv • Advanced Excel Tricks ► https://bit.ly/3CGCm3M • Excel Formulas Made Easy ► http://bit.ly/2t3netw • Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J • Connect with us! • LinkedIn ► / 18737946 • Instagram ► / computergaga1 • Twitter ► / computergaga1

#############################

New on site