## How to return Multiple Items using DATEDIF

The DATEDIF function is a must-learn function if you want to do date calculations. Generally, it is used to get the difference between two dates. Here is what you need to know to use the function properly: It is not a document, so it will not populate among Excel Date...

## How to Lookup Items in a List

Looking up items in a list is easy when we use the COUNTIF function. COUNTIF function returns a count of number of times a criterion appears in a dataset. =COUNTIF(dataset, criterion) For example, in the image below, we are counting if the currencies appear in our...

## How to Use SUMIFS Function in Data Validation

Analysts spend between 60% to 80% cleaning data. Here is how to cut that time by using the SUMIFS function in Data Validation. Given the below data, how do you ensure staff is awarded only salaries within their job grade scale? Here are the 4 steps: Select the Salary...

## How to condition format duplicates for Long Numbers formatted as text

A friend recently asked me, “How do I condition format duplicates for Long Numbers formatted as text?” I thought…that is easy! Just go to condition formatting and select the in-built rule of highlighting duplicate rules. WRONG! Hardly did I know...

## How to Reverse Lookup Numbers and Text In Excel

Reverse lookup of numbers is easier than that of texts. Reverse Lookup Numbers For example, how do you look up the appointment date and time for a patient in the below data? The below video explains the steps Note: ⭐ It is possible to create an array of Date and Time...

## How to Return Multiple Columns in VLOOKUP Function

By default, VLOOKUP is set to return a Single column but with a small tweak, it can return multiple columns. =VLOOKUP(G2,B2:E24,{3,4},FALSE) The only trick is to put the multiple columns in curly braces. NB: You can insert the column numbers in any order. For example,...