## Calculate Harmonic Mean in Excel

There are different ways to calculate averages in Excel, and usually, people are using formulas such as arithmetic mean and median. Sometimes, these…

Posted On

## Find Column Index Number Using VLOOKUP in Excel

In Excel, we can use the VLOOKUP function to find a table’s column index number of a specific value. This tutorial shows how…

Posted On

## Target Formula in Excel

We can always use Excel formulas for their initial purposes, but we can also deploy them for different purposes. If we are working…

Posted On

## Use SUMPRODUCT and COUNTIF together in Excel

SUMPRODUCT and COUNTIF are two powerful functions in Excel that can be used together in formulas to perform various calculations, for example, return…

Posted On

## Sum and Ignore Errors in Excel

You can use the SUM function to add a range of cells in Excel. However, if some cells in the cell range contain…

Posted On

## Use VLOOKUP and INDIRECT Functions Together in Excel

You can use the VLOOKUP and INDIRECT functions together in Excel to look up a value in a table in a different worksheet…

Posted On

## Excel VLOOKUP With Multiple Results

Although VLOOKUP is a very useful formula and can help us get the results we want with success and easier, certain shortcomings are…

Posted On

## Return Blank Cell Instead of Zero in Excel Formulas

As we work with Excel, we may want to return blank cells instead of zeroes in formulas. For example, we could return blank…

Posted On

## VLOOKUP by Column Name in Excel

Most of the things that people use in Excel can be combined to achieve proper and adequate results. Using the VLOOKUP function is…

Posted On

## Sorting Order in the VLOOKUP function in Excel

VLOOKUP function is certainly one of the most widely used functions in Excel. Once we extract the data that we want from our…

Posted On