Monthly Archives: February 2013

SpeedTools AVLOOKUP2 & MEMLOOKUP versus VLOOKUP – Performance, Power and Ease-of-Use Shootout Part 2

Posted on February 27, 2013 by fastexcel

In part 1 I looked at how FastExcel SpeedTools MEMLOOKUP and AVLOOKUP2 compared to VLOOKUP and INDEX/MATCH for ease of use and power. This post will benchmark the performance of the SpeedTools lookups against the standard Excel functions. Download the … Continue reading →

Posted in Calculation, Lookups, UDF, XLL | Tagged , , , | 3 Comments

SpeedTools AVLOOKUP2 & MEMLOOKUP versus VLOOKUP – Performance, Power and Ease-of-Use Shootout Part 1

Posted on February 27, 2013 by fastexcel

Its time for some performance tests to see how the new functions in SpeedTools stack up against the standard Excel functions. First up is MEMLOOKUP and AVLOOKUP2 vs VLOOKUP! SpeedTools Lookups are easier to use, more powerful and less error … Continue reading →

Posted in Calculation, Lookups, UDF, XLL | Tagged | 2 Comments

SpeedTools Beta 3 – Win a SpeedTools Coffee Mug and SpeedTools License

Posted on February 5, 2013 by fastexcel

FastExcel SpeedTools Beta 3 FastExcel SpeedTools Beta 3 is a state-of-the-art set of tools to help you speed up calculation of slow Excel workbooks. Download the 30-day trial of FastExcel SpeedTools Beta 3 Download the SpeedToolsHelp file. (you may need … Continue reading →

Posted in UDF, VBA, XLL | 19 Comments