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 weeks 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. Find more great free tutorials at; http://www.computergaga.com *** Online Excel Courses *** Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► http://bit.ly/2klIl6H Excel Formulas Made Easy ► http://bit.ly/2t3netw The Complete Excel Course ► http://bit.ly/2HI7die Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J Connect with us! Google+ ► https://plus.google.com/+Computergaga Facebook ► http://www.facebook.com/computergaga Twitter ► http://www.twitter.com/computergaga1