Many people have a love hate relationship with what is perhaps Excel’s most powerful capability.
Normally you don’t use them enough to become completely comfortable with them, but when you do you wish you had more opportunity to use them.
Array Formulas
Array formulas and large ranges
What can you learn here? array formulas VBA using VBA profiler using worksheet profiler Are Array formulas viable with large ...
Array formulas and sumproduct
Using array formulas rather than sumproduct We looked at the use of sumproduct() previously. Lets repeat that using array formulas instead. Array formulas will give you more ...
Array Formulas Introduction
These are a much overlooked feature of Excel, largely because array functions can be hard to understand. The power of ...
Bit Twiddling
What is bit twiddlingSometimes you need to do many logical operations at once. For example, consider the problem where you ...
Leveraging sorted data with Match
What can you learn here? Optimization and profiling filling ranges using VBA using match to partition data Another approach to ...
Optimizing the array formula
What can you learn here? Optimization and profiling Filling ranges using VBA Array formulas I previously covered a VBA solution for ...
The birthday problem
This problem is often used to show that statistics are sometimes counter intuitive. If you try to imagine how many people you ...