O'Reilly logo

Special Edition Using® Microsoft® Office Excel 2003 by Patrick Blattner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7. Database Functions

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required