by Crispo Mwangi | Sep 7, 2016 | ADVANCED EXCEL
It is good to be able to do a Reverse Lookup but it is Awesome if you know how to return Multiple Items. Before you continue with the current article, Please revisit the Previous Article on reverse lookup as this is a continuation. Suppose you are managing a project...
by Crispo Mwangi | Sep 3, 2016 | ADVANCED EXCEL
In my research and tutoring excel, I have found that many people find the Reverse lookup concept to be among the top 10 complicated things in excel. This article hopes to shed more light than heat in demystifying the Reverse Lookup in excel. In the normal lookup, we...
by Crispo Mwangi | Aug 20, 2016 | INTERMEDIATE EXCEL
The ability to lookup values is a MUST have skills for all Excel users. If you cannot lookup you cannot excel in data analysis. In this article, I will show you  5  ways you can do a 2-way lookup in Excel. 1. USING SUMPRODUCT Using below sales data lookup and sum the...
by Crispo Mwangi | Aug 7, 2016 | INTERMEDIATE EXCEL
Array formulas come in handy when you want to look up and sum a large amount of data. Array formulas can replace multiple normal formulas, perform multiple calculations and return a single value as a result. For example, using below Main sales data in Quantity and a...
by Crispo Mwangi | Jul 30, 2016 | INTERMEDIATE EXCEL
COUNTIF is an excellent function to count only those cells whose value meets certain criteria. But as excellent as it is, it becomes a challenge to count Unique or Repeats in a range that contain duplicates. For example, Using the below data count; Total number of...
Recent Comments