## 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

## Selling Price Formula in Excel

The selling price is the amount a customer pays to buy a product or service. We show you how to calculate a product’s…

Posted On

## INDEX and MATCH with the LARGE Function in Excel

Finding cells that meet multiple criteria is a common task in Excel. In this tutorial, we look at how to use the combination…

Posted On

## Convert Number of Days to Weeks in Excel

Sometimes we may want to convert the number of days into weeks in Excel summary reports. Convert Number of Days to Weeks in…

Posted On