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

## How to Use Multiple Criteria in a VLOOKUP function

Many users think you cannot use multiple criteria in a VLOOKUP Function, but this is wrong. =VLOOKUP( G2&H2, CHOOSE( {1,2},sales[Name]&sales[Region],sales[Date]) ,2,FALSE) DOWNLOAD...

## How to Initialize Multiple Middle Names In Excel

Initializing a single middle name is easy using a simple 3 steps: =LEFT(name,FIND(” “,name)) & IF(COUNTIF(name,”* * *”),MID(name,FIND(” “,name)+1,1)&”. “,””) & RIGHT(name,LEN(name)-FIND(”...