This tip is about using the keyboard to activate the formula bar for editing the contents of a cell without the use of the mouse.
The situation may arise when you want to perform some calculation based on the top X or bottom Y values in a list. An example might be you wish average your top 3 golf scores or the bottom three scores depending on your requirements.
In this tip we will look at returning the cell address which contains the maximum value in a given range.
Usually either text or numbers are placed into cells, not usually both together. You can easily combine the two data types into a single cell.
Some times you may need to count the number of blank cells in a range.
There may be an occasion when you have a list of data and you want to count the number of cells in the range that contain a specific character. The best tool to achieve this is the COUNTIF formula.
When faced with a range of odd and even numbers Excel provides a number of ways in which you can count the number that are even and the number that is odd.
This Hint and Tip explains changing the Ms Excel settings to enable the the contents of the Formula Bar to be edited by pressing a keyboard key.
This hint and tip is about using the Find facility in Excel without using the Find dialog box.
Excel provides the options to place a function within a function. In other words the inner function is an argument of the outer function.