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