• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 15. Using Advanced Excel Databas... > Looking Up Data Using Functions

Looking Up Data Using Functions

You can thoroughly analyze the information in your database using Excel's database functions, or Dfunctions. All the functions begin with the letter "D" and require three pieces of information:

  • The range of your database. The range is the actual cell references of your database, from (and including) the left-most cell of your header row to the right-most cell of the last record (bottom row) of data.

  • The field. To perform the database functions, you will indicate a particular field (column) of your database on which you want the function to be performed.

  • The criteria. The criteria in this case is a reference to the cell locations that contain criteria specific to the function being performed. This is synonymous with the criteria range established earlier in this chapter, although you don't have to use the entire criteria range if only part of the range (one or more column headings with criteria appearing under the headings) is necessary to the action of the function.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint