Excel Formula tips and tricks to make you a champion in Excel. A lot can be done when you know the right Formula hack.
Want to get the word count in Excel? Believe it or not, Excel does not have an inbuilt word counter. But don’t worry. A cool bunch of excel functions (or a little bit of VBA if you’re feeling fancy) can easily do this for you. In this tutorial, I will show a couple of ways to count …
Do you think you know Excel Formulas? Here is a fun way to test it!! This blog post has a downloadable file (at the end) that has an Excel Formula Crossword in it. Go ahead and test your formula knowledge. Since I am a nice guy, I did not put a timer in it. Solve it at …
Imagine you have created a super long formula in Excel. While you are proud of yourself, there is a minor glitch. It is returning an error or an unexpected value. Now you have two options: Excel Formula Debugging Method #1 – F9 Key Here is how this works: For example, suppose you have the text …
In this blog post, I will show you a formula to get a list unique items from a list in excel that has repetitions. While this can be done using Advanced Filter or Conditional Formatting, the benefit of using a formula is that it makes your unique list dynamic. This means that you continue to get …
Excel has its own limitations, and in this blog post, I will show you how we can use one of the limitations to our advantage. Get the Last Number in a List in Excel using Excel VLOOKUP Function The largest positive number that you can use in Excel is 9.99999999999999E+307 (I tried this in Excel 2010). …
Today I am going to give you a powerful formula cocktail. The less-used INDIRECT() and ROW()Â function together with the MID() function can create a magnificent concoction. This triad enables you to get into the contents in a cell. and analyze each character separately. For example, suppose you have Excel123 in a cell, and you want …
In this tutorial, you’ll learn how to find the position of the last occurrence of a character in a string in Excel. A few days ago, a colleague came up with this problem. He had a list of URLs as shown below, and he needed to extract all the characters after the last forward slash (“/”). …
VLOOKUP is one of the most used functions in Excel. It looks for a value in a range and returns a corresponding value in a specified column number. Now I came across a problem where I had to lookup entire row and return the values in all the columns from that row (instead of returning a …
A lot of times people ask me to help them in rectifying an error in their nested IF function. And sometimes their formula is bigger than this blog post (seriously! not kidding). However, in some of the cases, this long formula can be cut short by using the VLOOKUP function. Avoiding Nested IF Function Consider …
©trumpexcel.com – Free Online Excel Training
