Conditional COUNT in Excel: Count cells meeting multiple criteria + Data Cleanup Tip
We have been provided with a top secret data of one lab situated at the very center of the earth. A team of vigilant individuals take readings of different parameters to monitor the temperature...
5 powerful Excel functions you are not using
When it comes to usability and application of Excel, it is almost as true as if it is an acknowledged fact. There is almost no profession in management of which Excel can't help on...
Extracting Integer and Decimal portion from a number in different cells – Part 1
When it comes to information then most of the time its about numbers and often numbers come with decimals i.e. numbers that are written as:
9.82
0.9856486
1021587.986244
But what if we are only interested in decimal portion...
Adding specific Prefix to All cells or Specific cells in Excel – 3 Methods...
A dear friend of mine contacted me early in the morning and the length of his message was evident that he has tried his best to get his head round the problem but in...
Extract First and Last word from text string using Excel Formula
Say you have several text strings and you want to separate the first and last words from each text string using Excel. This can easily be done using Excel formulas and a going little...
Count Specific Weekday or Weekdays within Data range containing Dates
Often we have to deal with dates as they form integral part of almost every data set. But what if you want to count specific weekdays within a large range of dates? This is...
How Excel LOOKUPs Work: Demystifying mighty functions with an example from past [1 of...
Functions to Excel is like Sense to Humans. Humans with absent sense are no better than crawlers walking on two legs, without functions Excel is just another program with ability to store information and...
Randomly Select a Name from a list in Excel – How To
Suppose you have a long long list of customers from which you have to select a random name. Now this is certainly not a problem if you have tens or even few hundreds of...
Create Data Validation lists from Unsorted data with duplicates in Excel [How To]
Today I finally decided to make an Excel dashboard on debtors aging analysis. The main reasons to do this dashboard were that:
I thought now enough knowledge has been delivered to my cult followers that...
Splitting/Extracting Username and Domain name in Email address using Excel [LEFT and FIND function...
A classical scenario to understand the excellence of Excel. There might be situations where we would like to split the email address in two parts i.e. the username (part at the left of @...