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