Chapter 2

Filtering and Querying a Data List

IN THIS CHAPTER

check Understanding how to filter and query a data list

check Using AutoFilter to filter out unwanted data

check Filtering a list with custom criteria

check Filtering a list on font color, fill color, or cell icons

check Using Database functions to compute statistics from records that match your filter criteria

check Performing external data queries with text files, web pages, and data files kept in other database sources

It’s one thing to set up a data list and load it with tons of data and quite another to get just the information that you need out of the list. How you go about extracting the data that’s important to you is the subject of this chapter. The procedure for specifying the data that you want displayed in an Excel data list is called filtering the data list or database. The procedure for extracting only the data that you want from the database ...

Get Excel 2019 All-in-One For Dummies now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.