Find The Last Value In Excel Row Using Index and Count

****SUBSCRIBE****** To my Excel at Excel Newsletter 3 FREE Excel Tips First Wednesday of EVERY Month http://www.howtoexcelatexcel.com and get my free Top Tips for Excel Ebook Immediately ****Other Places You Can Find Me For More Excel Tips*** ++Website http://www.howtoexcelatexcel.excel.com ++Twitter https://twitter.com/howtoexcelatex ++Pinterest http://www.pinterest.com/howtoexcelat I have used this formula on a regular basis to return the last value in my rows of data, handy if you add in new values every month to an Excel spreadsheet but always want to return the most recent or latest value like for example the most recent months sales. Learn how with this latest How To Excel at Excel Video Tip.