Welcome toExcel2007.Tips.Net
ExcelTips
Home Tips
Pet Tips
Word2007 Tips
Specifying the Number of MRU Files
Seeing How Excel Evaluates Formulas
Highlighting a Cell if It Contains Specific Text
Creating a List of Worksheet Formulas
The following articles are available. Click the article's title (shown in bold) to see the associated article.
Extracting Records from a List that Match a Criterion. If you have a bunch of data in an Excel worksheet, you may need to work with just a subset of that data. One way to do that is to extract just the data that meets a particular criterion you specify. Excel makes this easy to do using the advanced filtering capabilities of the program.