5 Functions that Return Multiple Results In a Lookup
Most lookup functions by default return either the 1st or the last match item. How do you return...
The Difference Between Search and Find Function in Excel
The SEARCH and FIND functions in excel both return the position of a text in a text string. For...
How to Conditional Format Date or Time in a Datetime
The first step to conditional formatting a date or time in a DateTime is understanding how Excel...
How to Calculate Income Tax In Pakistan
On Linkedin, after sharing my article on 7 Ways to Calculate Income tax, I got a question on how...
7 Ways to Calculate PAYE Tax In Excel
Benjamin Franklin once said, "in this world, nothing can be said to be certain, except death and...
How to Count Distinct, Unique and Duplicates In Excel
The first step in counting distinct, unique, and Duplicates is knowing the difference between...
How to Clean Any Special Character From a String
The ability to clean data is one of the most valuable skills for any data analyst. Below are 3...
3 Ways to Count Partial Matches in a String
Recently a friend approached me with the below issue. How do you compare if the applicant has all...
How to Count Uppercase Lowercase or Numbers in a String
Here are 3 methods you can use to count uppercase lowercase or numbers in a string. Using a...
5 Ways To Extract Numbers From a String in Excel
Extracting numbers from a string in excel is a must-have skill in data cleaning. There are...
How to List Missing Numbers In a Sequence
Missing numbers in a sequence can lead to wrong results in data analysis, especially if you are...
How To Prevent Duplicates In Data Entry in Excel
Data validation is very important as it prevents bad data entry and thus saves time in data...