Excel how to count the number of cells that contain texts

Excel how to count the number of cells that contain texts

You can carry out simple arithmetic operations on excel, and it mainly involves numbers. However, you can also manipulate texts and other special characters in your cells. When dealing with texts and numbers, you may wish to know the number of cells containing texts. There are several formulas in excel that you can use for … Read more

How to find the highest number in a column

How to find the highest number in a column

Finding the highest number in Excel can be very useful when you have a long list of items. But some people do not know how easily one can find the highest number. Others find the highest number manually making it a very tiresome process. Although that can be an effective way for very small filled … Read more

Find and Replace Using Multiple Values

Find and Replace Using Multiple Values

Find and replace is an excel feature used to search for specific data in an excel worksheet or within a workbook and what you do with the data found. This article will explore different ways you can use find and replace together with using advanced find features. Scanning through columns and rows in a large … Read more

How to Find text in a range and return cell reference

How to Find text in a range and return cell reference

Advanced excel formulas can be used to lookup values or text in Excel and return the relative cell address. An INDEX function can be used to MATCH the lookup value in a range of cells. INDEX function can be used in two ways, INDEX reference and INDEX array The reference form returns the reference to … Read more