O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

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

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

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