## Get Cell Value From Address in Excel

When working with Excel, in certain instances, you would like to know the value of your cell based on its location. To do…

Posted On

## Convert Month Number to Month Name in Excel

In Excel, there are solutions for every problem that we have. This refers to both mathematical, logical, and graphical issues, as well. It…

Posted On

## Sum Only If Value in Excel Cell Is Number and Not Text

Sometimes we have a dataset that contains both numeric and text values in a column. We may want to sum only the numeric…

Posted On

## Convert Numbers to Text With Commas in Excel

Suppose you have a dataset in Excel that has long numbers. To improve readability, you may want to convert the numbers to text…

Posted On

## Check If Cells in Excel Contain any Text

Sometimes you may want to check if cells in a worksheet contain any text. This tutorial shows you a technique for checking if…

Posted On

## Check If an Excel Cell Contains a Number

At times you may want to check if cells in an Excel worksheet contain numeric characters. This tutorial shows you one technique for…

Posted On

## Calculate the Average Percentage of Marks in Excel

Excel is a perfect tool for all mathematical operations and visual presentation of data. It can be used to combine the two, as…

Posted On

## Return Min, Max, or Average Using Vlookup in Excel

It is nothing unusual to combine a few Excel formulas to get the results we need. Such is the case with the VLOOKUP…

Posted On

## Find the Average of Excel Range Ignoring Zeroes

Sometimes we may want to exclude zero values in the calculation of the average of a range. This tutorial shows how to find…

Posted On

## Get nth Match with INDEX, MATCH, and SMALL in Excel

We can use the combination of INDEX, MATCH, and SMALL functions to find the data that is in the nth position of a…

Posted On