Today we explore this ongoing debate over VLOOKUP vs. INDEX/MATCH. I say it’s a false dichotomy and unnecessary confusion.
THE PINOCCHIO THEORY In 1977 Bootsy Collins released the hit song Pinocchio Theory. Its main warning is: If you fake the funk, your nose will grow There are a lot of long noses in the data world–specifically with folks who continually bash Excel and write its obituary. Excel users cannot […]
“Teach me Excel” is a hard request to satisfy. Here is why and 5 suggestion on how to get started learning Excel.
Mynda Treacy’s recent blogpost at MyOnlineTrainingHub is a hot one! Excel Custom Validation to Limit Entries poses a fun and excellent solution that Santa probably deals with every year: How does Santa set up Excel to allow a kid to request no more than 3 presents for Christmas? Mynda creates a solution that takes us […]
We all want to get to the sexy data and none of us are immune to the pain of cleaning data before it’s useful. Today we look deeper into this problem.
After Mike Girvin’s appearance on Excel TV I saw the array formula light!
Here’s an example of an array formula used to find the closest due date for people and their list of tasks.