Get the Last Value in a Row - Excel Formula

In this video, we look at how to get the last value in a row using a formula. In this example, the last value is the current week's data. We always want to see the current week, even as time goes by and more weeks are added. This formula dynamically returns the last value in the row even as it expands An example is shown for a list of values, then it is taken further into a reporting scenario and running from a drop-down list. Here are the timings of the video. 00:00 - Introduction 00:43 - Formula to get the last value in a row 03:12 - Return the second from the last value 04:03 - Test the formulas for the last two values 04:29 - Return the last value for a specific product 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/37XSKfZ