TextAfter function in Excel is used to extract text based on the given condition after a character, word, delimiter, multiple delimiters. Additionally, the TEXTAFTER function can extract text from backwards as well. Return a specific value in case if delimiter is not found.
When working with data in excel, we see the same data repeat multiple times. In other words, we see duplicate entries in data. If you want to do data analysis the first step you need to do is to remove these duplicate entries. If not then you will end up getting up incorrect results. This …
UNIQUE Function in Excel – Best way to Remove Duplicates Continue Reading »
In this article let us understand about the Excel COLUMN Function. The Formula Syntax of Column Function in Excel. What is Excel Column Function The purpose of Excel Column function is to know or get the column number for a given cell or range. This function returns the column number(s) depending on the input. Note …
Match function is one the most important and widely used functions in Excel. In this post let us see how to use the Match Function in excel. Syntax of Match function and few examples on how to use the Match function in excel. What is MATCH Function in Excel Match Function in Excel is under …
How to use MATCH Function in Excel – Syntax and Examples Continue Reading »
The Index function in Excel is one of the most used functions in excel. It is categorized under Lookup and Reference functions. In this article we will see and learn How to use and Syntax along with few examples. What is Index Function in Excel The excel INDEX function returns a value or the reference …
INDEX Function in Excel – How to use with Examples Continue Reading »
VLOOKUP is one of the most important formula/ function in excel. In this post I will explain how to use VLOOKUP function in excel in detail and also the limitations of it. The more you use it, the simple it becomes. Before getting into the post let’s understand and break few Myths about VLOOKUP Function. …
In this post let us see how to use the if function in excel with practical examples. DOWNLOAD the practice workbook to follow along. In our day to day lives we come across different situations where we need to choose/ make a decision based on the options available. Every decision we make/ need to make …
IF Function in Excel with Practical Examples Continue Reading »
