Recent Comments
Category Archives: UDF
FastExcel V3 Released with Introductory Offer
FastExcel has been used successfully by thousands of users since it was first launched in 2001. The last version 2.4 was introduced in 2008 and since that time there have been major changes to Excel with Excel 2007, 2010 and 2013, … Continue reading
Posted in Calculation, Lookups, Memory, UDF, VBA, XLL
Leave a comment
Inserting a UDF and Launching the Function Wizard from VBA
In a previous post I suggested you could do this by entering the function using VBA into the selected cell using a comma as the argument to the function, for example =LISTDISTINCTS.SUM(,) , and then calling the function wizard using … Continue reading
Posted in UDF, VBA, XLL
Leave a comment
Finding out if a function is Volatile or Multithreaded using VBA: UDFs for UDFs
Part of my new Profiling Formulas and Functions command requires the code to determine whether a Function is a native built-in Excel function, or an XLL function, or some other kind (VBA, Automation). And I also want to know if … Continue reading
Posted in Calculation, UDF, VBA, XLL
Leave a comment
Exploring Conditional Format Performance Part 3: What’s slow, whats buggy and whats faster!
This is the third in a series of Posts on Conditional Formats (see part 1 and Part2). This post looks at the effects on the performance of Conditional Formats of: Application.Screenupdating Application.EnableConditionalFormatsCalculation Application.Calculation Whether the cells containing the conditional formats … Continue reading
Posted in Calculation, Formatting, UDF, VBA
Tagged conditional formats bugs, conditional formats slow
11 Comments
Exploring Conditional Format Performance Part 2: What’s slow, whats buggy and whats faster!
This is the second in a series of Posts on Conditional Formats (see part 1). This post looks at the effects (and the resulting bugs!) on Conditional Formats of: Application.Screenupdating Application.EnableConditionalFormatsCalculation Application.Calculation Whether the cells containing the conditional formats are … Continue reading
Posted in Calculation, Formatting, UDF, VBA
Tagged conditional formats bugs, conditional formats slow
Leave a comment
Exploring Conditional Format Performance Part 1: What’s slow, whats buggy and whats faster!
Patrick wanted to know if I had any information on Conditional Format calculation and performance, and I have not looked at it for several years, so here goes! I have done a series of experiments, using Excel 2007, 2010 and … Continue reading
Posted in Calculation, Formatting, UDF, VBA
Tagged conditional formats bugs, conditional formats slow
4 Comments
Finding missing items in lists: VLOOKUP vs COMPARE.LISTS performance and ease of use
Returning to the subject of finding the missmatches between 2 lists I want to compare using VLOOKUP with using SpeedTools COMPARE.LISTS. Test Data My test data consists of 2 lists of 500000 6-digit numbers. Most of these numbers match, but … Continue reading
Posted in Calculation, Lookups, UDF, XLL
Leave a comment
SpeedTools AVLOOKUP2 & MEMLOOKUP versus VLOOKUP – Performance, Power and Ease-of-Use Shootout Part 2
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 fast lookup, lookup benchmark, slow lookup, vlookup
3 Comments
SpeedTools AVLOOKUP2 & MEMLOOKUP versus VLOOKUP – Performance, Power and Ease-of-Use Shootout Part 1
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
