Chapter 7. Database Functions
In this chapter
Database Functions Overview and Syntax
Database functions operate over ranges that can span more than one row or column. One of the key benefits of database functions is the capability to set up criteria ranges for creating complex criteria. For example, if you have to look up maximum or minimum numbers through a period of time over a span of years, database functions work great for a quick reference lookup. As with all functions, you can reference the database with a range name or with the cell references; either way works.
Although database functions as well as many other functions work well for managing and looking ...
Get Special Edition Using® Microsoft® Office Excel 2003 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.
