Monthly Archives: September 2011

Does MATCH handle mixed alphabetic and numeric data when sorted?

I was doing some testing on my new XLL advanced LOOKUP and MATCH functions, comparing them to MATCH when I came across some quirks (actually I think some of them are bugs). Mixed Characters and Numbers So suppose we have … Continue reading

Posted in Calculation | 3 Comments

False Volatility – Is this a bug?

There was an interesting discussion here about using Application.Volatile False in a VBA UDF. It seems that if you create a VBA UDF like this one: and call it from a cell when x refers to another cell that contains … Continue reading

Posted in Calculation, UDF, VBA, XLL | 5 Comments