• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 28. Working with Lists and Datab... > Finding and Filtering Data in a List

Finding and Filtering Data in a List

When working with lists, you can use the Find shortcut (Ctrl+F) to search for any value in the list. That technique is useful if you want to jump quickly to a specific unique value in the list. More often, however, you'll want to extract details from a list instead of simply jumping to a single record. In that case, use filters to hide all records except those that match criteria that you specify. In a list that contains hundreds or thousands of rows, defining a filter helps you see a small number of related records together, making it easier to compare data and identify trends.

For example, in a list of daily high, low, and closing stock prices that includes data for many companies, you might want to see only those records in which the entry in the Symbol column is equal to KO (that's the Coca-Cola Company, for those who don't know ticker symbols by heart). Or, if you import product inventory information from a database into an Excel list, you can use filters to show only items that are currently out of stock, making it easy to build a reorder list.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint