by Crispo Mwangi | Oct 19, 2022 | INTERMEDIATE EXCEL
Among many misconceptions about the VLOOKUP function is that it cannot return items repeated n times. This is not true! For example, Using the data below, can you return the names of the customers who have bought 3 times using VLOOKUP? Here are the steps: Create a...
by Crispo Mwangi | Oct 6, 2022 | INTERMEDIATE EXCEL
On Default, VLOOKUP is not case sensitive thus it does not do an Exact match lookup. It is even harder for VLOOKUP to do an exact partial match lookup and return multiple results. This article will show you how to resolve the above difficulties by nesting IF, SMALL,...
by Crispo Mwangi | Sep 30, 2022 | BASIC EXCEL
This is part 1 of the 4 part series on What if analysis. This blog will cover the Goal Seek feature. What is the Goal Seek feature? Goal seek enables you to see how a change in one value in a model can change the final result. Instead of guessing what impact a value...
by Crispo Mwangi | Sep 23, 2022 | BASIC EXCEL
If you are not using the excel fill series in your day-to-day tasks you are wasting a lot of time You can quickly enter sequential numbers or numbers following a pattern using the Autofill options. And since excel stores Dates & Times as numbers, these can also be...
by Crispo Mwangi | Sep 16, 2022 | ADVANCED EXCEL
Most lookup functions by default return either the 1st or the last match item. How do you return all matching multiple results in a lookup? How do you return all the customers who bought the product below? USING VLOOKUP TO RETURN MULTIPLE RESULTS...
Recent Comments