11. Filtering and Consolidating Data


This chapter shows you how to use Excel’s filtering functionality to look at just the desired records. It also shows you how to filter by text, values, and dates. Topics in this chapter include the following:

Removing duplicate rows

→ Creating a unique list of items

→ Filtering for specific records

Consolidating information from multiple workbooks

Filtering a protected sheet

→ Focusing on specific data by filtering by color or icon

Filtering and consolidating data are important tasks in Excel, especially when you are dealing with large amounts of data. The filtering tools can quickly reduce the data to ...

Get My Excel 2016 now with O’Reilly online learning.

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