by Crispo Mwangi | Jun 29, 2017 | ADVANCED EXCEL, INTERMEDIATE EXCEL
When is the last time you used the REPT function in Excel? REPT is one of excel’s little-known, overlooked, and underutilized function, yet very useful. Generally, REPT returns a specific text string a specified number of times....
by Crispo Mwangi | Jun 16, 2017 | ADVANCED EXCEL, INTERMEDIATE EXCEL
IF function is one of the most used functions in Excel. In my opinion, it is the foundation of all programming and Excel formulae mastery. However, it is also one of the most misused functions, especially Nested IF. Especially now with Excel 2007 and beyond,...
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,...
Recent Comments