Excel Tip Using An Array Formula To Calculate Most Improved Sales

Read the blog post to this video here http://www.howtoexcelatexcel.com/formulas/formula-friday-find-the-most-improved-sales-area-with-excel/ Do you want become an expert in Excel?. Then take a look at Mynda Treacy's Excel Expert course. The Link is here..http://www.mothresource.com/152-8-3-11.html Download the example Excel workbook to this video herehttp://www.howtoexcelatexcel.com/formulas/formula-friday-find-the-most-improved-sales-area-with-excel/ ****SUBSCRIBE****** to my Excel at Excel newsletter 3 FREE Excel Tips every 15 days http://www.howtoexcelatexcel.com ----------------------------------------­--------------------------- Website http://www.howtoexcelatexcel.excel.com Twitter https://twitter.com/howtoexcelatex Pinterest http://www.pinterest.com/howtoexcelat -------------------------------------------------------------------------- Today we are diving into the arena of the Array Formula with a simple straightforward example where I will show you how to quickly calculate the most improved sales area from one month to the next. In our example we have four sales areas, looked after by four sales people. North, South, East and West Sales for two months- November and December 2014- let’s see which areas had the most improved sales using both the November and December sales figures.