My Excel 2016

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 ...