by Crispo Mwangi | Feb 3, 2017 | BASIC EXCEL, INTERMEDIATE EXCEL
In the previous article, we looked at 6 ways to find the last or Nth occurrence in a Sorted list in excel. Unsorted list poses a challenge since you need to find the occurrence using multiple criteria. To show the different methods I have created a list of Customers...
by Crispo Mwangi | Jan 27, 2017 | BASIC EXCEL, INTERMEDIATE EXCEL
Finding the Nth or the Last value in a sorted or unsorted list can pose a challenge if you do not understand which functions to use. This article will show you different ways to carry out this sort of find and retrieve an item in a sorted list. How to handle the...
by Crispo Mwangi | Jan 14, 2017 | INTERMEDIATE EXCEL
Learning how to use conditional formatting in excel can save you a lot of time when you need to visually highlight important information in a worksheet. At a basic level, it can be used to highlight duplicates, values within certain thresholds, Top or Bottom N items,...
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