Excel Formula tips and tricks to make you a champion in Excel. A lot can be done when you know the right Formula hack.
There is no inbuilt function in Excel to extract the numbers from a string in a cell (or vice versa – remove the numeric part and extract the text part from an alphanumeric string). However, this can be done using a cocktail of Excel functions or some simple VBA code. Let me first show you …
Watch Video –Â Lookup the Second, the Third or the Nth Matching Value When it comes to looking up data in Excel, there are two amazing functions that I often use – VLOOKUP and INDEX (mostly in conjunction with the MATCH function). However, these formulas are designed to find only the first instance of the lookup …
When using the VLOOKUP formula in Excel, sometimes you may end up with the ugly #N/A error. This happens when your formula can not find the lookup value. In this tutorial, I will show you different ways to use IFERROR with VLOOKUP to handle these #N/A errors cropping up in your worksheet. Using the combination …
Excel has some powerful functions to calculate the number of days between two dates in Excel. These are especially useful when you’re creating Gantt charts or timelines for a proposal/project. In this tutorial, you’ll learn how to calculate the number of days between two dates (in various scenarios): Calculating the Total Number of Days Between …
A timestamp is something you use when you want to track activities. For example, you may want to track activities such as when was a particular expense incurred, what time did the sale invoice was created, when was the data entry done in a cell, when was the report last updated, etc. Let’s get started. …
If you have a list of numbers, it easy to rank it using the RANK function. However, if you have these numbers within various groups, it could be a challenge to find the rank within the groups. For example, as shown below, there are two groups (A and B) with 5 items in each group. Each item …
By default, the lookup value in the VLOOKUP function is not case sensitive. For example, if your lookup value is MATT, matt, or Matt, it’s all the same for the VLOOKUP function. It’ll return the first matching value irrespective of the case. Making VLOOKUP Case Sensitive Suppose you have the data as shown below: As you …
Excel VLOOKUP function, in its basic form, can look for one lookup value and return the corresponding value from the specified row. But often there is a need to use the Excel VLOOKUP with multiple criteria. How to Use VLOOKUP with Multiple Criteria Suppose you have a data with students name, exam type, and the Math …
Using a combination of Excel functions and the date of birth, you can easily calculate age in Excel. You can either calculate the age till the current date or between the specified period of time. The technique shown here can also be used in other situations such as calculating the duration of a project or the tenure …
©trumpexcel.com – Free Online Excel Training
