

Email Us

[email protected]

[email protected]

[email protected]

 

NITA/TRN/2073

IHRM►C00453

  • Home
  • About Us
    • Our Partners
    • Our Company
    • Our Team
      • About Joan
      • About Crispo
      • About Abied
      • About Levy
      • About John
  • HR
  • ADVANCED EXCEL
  • INTERMEDIATE EXCEL
  • BASIC EXCEL
  • CHARTS
  • SUBSCRIBE
  • CONTACTS
How to condition format duplicates for Long Numbers formatted as text

How to condition format duplicates for Long Numbers formatted as text

by Crispo Mwangi | Jan 20, 2023 | INTERMEDIATE EXCEL

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

How to Reverse Lookup Numbers and Text In Excel

by Crispo Mwangi | Jan 8, 2023 | INTERMEDIATE 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

How to Return Multiple Columns in VLOOKUP Function

by Crispo Mwangi | Dec 30, 2022 | INTERMEDIATE EXCEL

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

How to Use Multiple Criteria in a VLOOKUP function

by Crispo Mwangi | Dec 26, 2022 | INTERMEDIATE EXCEL

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

How to Initialize Multiple Middle Names In Excel

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(”...
HLOOKUP To Return Multiple Items In Excel

HLOOKUP To Return Multiple Items In Excel

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...
« Older Entries

Follow Us

Follows
  • Twitter
    5.5k Followers
  • LinkedIn
    5.1k Followers

Categories

  • ADVANCED EXCEL
  • BASIC EXCEL
  • CHARTS
  • HR
  • INTERMEDIATE EXCEL

Recent Posts

  • How To Clean & Split Dirty Data In PowerQuery
  • How to condition format duplicates for Long Numbers formatted as text
  • How to Reverse Lookup Numbers and Text In Excel
  • How to Return Multiple Columns in VLOOKUP Function
  • How to Use Multiple Criteria in a VLOOKUP function

Recent Comments

  • Rick Rothstein on How to Count Uppercase Lowercase or Numbers in a String
  • Crispo Mwangi on XOR logic in Excel
  • sandeep kothari on XOR logic in Excel
  • sandeep kothari on XOR logic in Excel
  • Crispo Mwangi on How to Conditional Format Date or Time in a Datetime
CrispExcel