Welcome toExcel2007.Tips.Net
Beauty Tips
ExcelTips
Health Tips
Legal Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
The following articles are available for the 'Advanced Filtering' topic. 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.