8. Filtering and Consolidating Data

In This Chapter

• Remove duplicate rows.

• Create a unique list of items.

• Combine information from multiple workbooks.

• Focus on specific data by filtering by values, color, or icon.

This chapter shows you how to use Excel’s filtering functionality to look at just the desired records. It also shows you how to create a list of unique items, delete duplicates, and consolidate data.

Filtering and consolidating data are important tools in Excel, especially when you are dealing with large amounts of data. The filtering tools can quickly reduce the data to the specific records you need to concentrate on. The consolidation tool can bring together information spread between multiple sheets or workbooks.

Preparing ...

Get Excel® 2013 Absolute Beginner’s Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.