Skip to Main Content
Computing with Excel and VBA
book

Computing with Excel and VBA

by S.I. Krishan
August 2008
Beginner to intermediate content levelBeginner to intermediate
298 pages
10h 49m
English
Jones & Bartlett Learning
Content preview from Computing with Excel and VBA
Data Summarization with Subtotals 159
You will notice that these formulas produce logic answers of TRUE or FALSE only.
When using the formulas to specify the filtering criteria, the cells above the formula
cells in the criteria range do not need any label or heading; however, those cells must be
included when specifying the criteria range in the Advanced Filter dialog box. The result
produced by filtering through the above two formulas will yield four funds that have
above average five-year returns and below average expense ratios.
Although advanced filtering using formulas can be powerful, the expanded options
in the AutoFilter ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Programming with VBA Starter

Excel Programming with VBA Starter

Robert F Martin
Programming Excel with VBA and .NET

Programming Excel with VBA and .NET

Jeff Webb, Steve Saunders

Publisher Resources

ISBN: 9780763756680