by Crispo Mwangi | Dec 23, 2022 | INTERMEDIATE 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(”...
by Crispo Mwangi | Dec 2, 2022 | ADVANCED EXCEL
Here are 4 ways to Initialize the First and/or Second Name in Excel This article is inspired Bhavya Gupta Youtube Video. He elegantly solves the issue using LAMBDA function but I will try to solve solve it using normal TEXT functions. Using REPLACE & FIND Function...
by Crispo Mwangi | Nov 24, 2022 | INTERMEDIATE EXCEL
Of all lookup functions, HLOOKUP is among the least famous ones. It looks up a value in the first row and returns any corresponding item in another row. Look up value MUST be in the top row of a table. How do you make it return multiple items? It’s default...
by Crispo Mwangi | Nov 16, 2022 | INTERMEDIATE EXCEL
VLOOKUP function is mostly underrated and assumed that it cannot return multiple items. The only trick is to use row numbers as lookup values…VLOOKUP can loop through numbers one at a time and return corresponding values. =VLOOKUP(...
by Crispo Mwangi | Nov 9, 2022 | BASIC EXCEL
Unlike the OR function which returns TRUE if only 1 condition is TRUE, the XOR function returns TRUE if the number of TRUE conditions is ODD and FALSE if the number of TRUE Conditions is EVEN. Like the OR Function, at least one of the test conditions must evaluate to...
Recent Comments