Using Database Functions

image with no caption

The database functions are particularly useful because they analyze data from tables with headings (field names) and data rows (data records). The block of information in rows and columns constitutes a database.

Using the database functions is made easier if the following rules are observed:

  • Make sure lists have column headings.

  • Make sure lists don’t contain empty rows or columns.

  • Make sure lists don’t contain linked cells.

In Excel 2003 and earlier, the usage of Excel as a database was stretched to its limits pretty quickly because a table was limited to 65,536 rows. In Excel 2007 this limit was extended: Now each table for ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.