Here's our Microsoft Office Tip for.. August 16, 1999
Click Here to see a complete list of all of our previously released Tips!
Go To It
Clearly, we're all caught up in the maelstrom of excitement that is the Go To command; I haven't been able to stop playing with it since I discovered it. But my near-psychotic obsession is your pot of gold because I've hit on yet another indispensable adaptation of this feature.
Suppose--just suppose--you have a column of entries that contain some numbers and some text. To count how many of either you have in the column, follow these steps:
1. At the right end of the status bar (that's the bar on the bottom of your Excel display), right-click the largest "space" and, from the shortcut menu that appears, select Count.
2. Select the column containing the items you want to count.
3. Choose Edit + Go To.
4. Click Special.
5. In the Go To Special dialog box, select Constants; then under Formulas, deselect all but the type of item you want to count.
6. Click OK.
As you might expect, Go To selects the items in your column. If you check the status bar, you can see how many types of items there are.
Pretty cool, eh?