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

Chapter 13. Analyzing Data with Lists > Using Complex Criteria to Filter a List

Using Complex Criteria to Filter a List

The AutoFilter should take care of most of your filtering needs, but it's not designed for heavy-duty work. For example, AutoFilter can't handle the following accounts-receivable criteria:

  • Invoice amounts greater than $100, less than $1,000, or greater than $10,000

  • Account numbers that begin with 01, 05, or 12

  • Days overdue greater than the value in cell J1


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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