If anybody asks me what is the best function in excel I am drawn between Sumproduct and Data Tables, Both make handling large amounts of data a breeze, the only thing missing is the Spandex Pants and Red Cape!
Please note that this post is unusually large by standards. This is a Guest Post by Hui, an Excel Ninja and One of the Moderators of our Forums.
