## 7+ WAYS TO LOOKUP NUMBER VALUES

The ability to lookup number values in excel is a must-have for all data analysts. Some Excel users just know the basic VLOOKUP function but there are 7 more functions to lookup values. The more lookup function you know the better you become in retrieving numbers like...

## HLOOKUP with multiple criteria (OR/AND logic)

When was the last time you comprehensively looked at the HLOOKUP function and its alternative? To look up data horizontally, many excel users tend to use HLOOKUP but it has its limitations. So what are the alternatives? In this article,...

## FOMC Dot Plot Chart Using REPT Function

On Linkedin, a user commented on how he has been struggling to recreate the Federal Reserve dot Plot. After being puzzled for almost 2 years, he came to realize how REPT function in excel can be of great help. After searching the web, I have found there is no...

## 7 WAYS TO USE EXCEL REPT FUNCTION

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....

## 7 ALTERNATIVES TO NESTED IF FUNCTION

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, you can...

## FIND THE LAST OR Nth OCCURENCE IN EXCEL USING MULTIPLE CRITERIA

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...

## FIND THE LAST OR Nth VALUE IN EXCEL (SORTED LIST)

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...

## Highlight a Sample In a Range or Text that contain certain Values

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,...

## DAVERAGE vs AVERAGEIF & DCOUNT vs COUNTIF

We have been exploring on database functions for the last two articles ( EXCEL DATABASE FUNCTION and EXCEL DSUM FUNCTION.) This article will examine  DAVERAGE & DCOUNT and how they compare with their equivalent AVERAGEIFS & COUNTIFS. Will the Database...

## EXCEL DSUM FUNCTION

If you are new to Database Functions, read this Introduction to Database Functions first before you continue. In this article, we shall look into the uses of DSUM function which is one of the EFFICIENT Excel sum functions with criteria. Below are some of its uses;...