by Crispo Mwangi | May 25, 2020 | Advanced Excel
This post is inspired by Dave Bruns’s post on Two-way approximate match multiple criteria. Having read Dave’s article I thought… “Is there an easy way of doing this using XLOOKUP instead of INDEX/MATCH?” 🤔 Option 1: Using IF Function...
by Crispo Mwangi | May 14, 2020 | Advanced Excel
NEVER has there been so much noise (fuss) in the Excel Community as it was during the introduction of the XLOOKUP FUNCTION. Excel experts called it “Functions Killer”, “Ultimate Lookup Function”, “Single Most Important function”,...
by Crispo Mwangi | Apr 12, 2019 | Advanced Excel
“Excel Flash Fill Is A Brilliant Time Saver,” writes Life hacker Australia. “In fact, it’s so good it feels like magic,” says Tech Radar “Flash Fill brings the power of text manipulation to the hands of common, non-technical, everyday...
by Crispo Mwangi | Aug 17, 2018 | Advanced Excel, Beginner, Excel Beginner
There are times when you want to look up and retrieve values based on a list. Normal filtering can only take up a maximum of two items and limited criteria conditions. In this article, you shall learn 4 ways to lookup items not matching a list. For example, below we...
by Crispo Mwangi | Aug 4, 2018 | Advanced Excel
Duplicates can be a pain in data analysis leading to the wrong conclusion. This is why knowing how to lookup unique values is very important. This article shows 5 ways to tackle duplicate data menace and create a dynamic lookup table with unique values. The task is to...