10+ ways to SUM Top N values in Excel data range – Ready to...
We all love to add things up. Its always good if things add up to the way we want. And no doubt from Excel newbie to pro everyone uses SUM formula. We have recently...
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 @...
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...
Creating Currency Converter in Excel [How To]
In the world we live in where almost every country has its own distinct currency and value, we almost always feel a need to convert one currency to another. These days it is easy...
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...
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...
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...
Understanding Excel CHOOSE() function [Intro]
"Your life is what you choose it to be"
In essence whatever we give to life it returns the same. If we give peanuts, it will return peanuts. If it is 1 life will return...
How Excel VLOOKUP Works: How to use it – Explanation with Example
While explaining LOOKUPs in my previous post, I explained how in daily life we apply lookup functions in different situations and to understand better I explained the example of mathematical lookup table to find...
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...