Chapter 2
Filtering and Querying a Data List
IN THIS CHAPTER
Understanding how to filter and query a data list
Using AutoFilter to filter out unwanted data
Filtering a list with custom criteria
Filtering a list on font color, fill color, or cell icons
Using Database functions to compute statistics from records that match your filter criteria
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.
