Excel Relative and Absolute References – Explained

In our last post about Finding duplicates in Excel, we created a clever formula to find only single instance of a duplicate value using the concept of Excel absolute references. In that post, we were unable to discuss further Absolute and Relative references, but today we will understand what these references mean.Excel Relative … [Read more...]

VBA InStr and InStrRev – How to Use

As the name suggests VBA InStr function looks for a substring embedded inside another string and then returns its starting position.  If it cannot find the string inside the parent string then it returns 0. It is a very important function among the string functions in VBA. It is probably the best function to perform string search … [Read more...]

Excel Nested If’s – Explained

In our last post, we talked about the IF Statement, which is one of the most important functions in Excel.  The limitation of the IF statement is that it has only two outcomes. But if you are dealing with multiple conditions then Excel Nested If’s can come in very handy.Nested if’s are the formulas that are formed by multiple if statements one … [Read more...]

Excel COUNTIF Function – How to Use

As the name suggests Excel COUNTIF Function is a combination of Count and IF formula. In plain English, COUNTIF Function can be described as a formula that can be used for counting the number of cells that fulfill a particular condition, within a predefined range.How Excel Defines COUNTIF FunctionMicrosoft Excel defines COUNTIF as a formula … [Read more...]

SUM Function in Excel – How to Use

SUM Function is a very popular and useful formula in Microsoft Excel. It is one of the most basic, widely used, and easy to understand arithmetic functions in Excel. As the name suggests SUM Function in Excel performs the addition of numbers. Sum Function can accept numbers both as individual arguments and also as a complete range of cells.How … [Read more...]

Search Function in Excel – How to Use

As the name suggests Search Function in Excel can help you to locate one string (or character) inside another string. The output of the Search function is a number that is equal to the start position of the substring inside the input string. Search function when combined with Mid Function can be used as a powerful substring method.How … [Read more...]

Excel Match Function – How To Use

Excel provides many formulas for finding a particular string or text in an array. One such function is MATCH, in fact Match function is designed to do a lot more than this. Today we are going to learn how to use the Excel Match function. Basically what match function does is, it scans the whole array range in order to find the specified text and … [Read more...]

SubTotal Function In Excel – How to Use

Subtotal Function in Excel is a wonderful formula that can be used to perform some specific arithmetic and logical operation on a defined range of cells.Microsoft Excel defines Subtotal Function as “It returns a subtotal in a list or database”.Subtotal formula takes two arguments:1. Operation Code2. Range of Cells.In the below … [Read more...]