Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
a common characteristic function Function of this type have some common characteristics: (1) Each function has three parameters: database, field, and criteria. Point function of these parameters used in the region of the worksheet. (2) In addition to GETPIVOTDATA function, the other 12 functions with the letter D at the beginning. (3) If the letter D will be removed from the database can be found in fact the majority of functions have been other types of Excel had a function. For example, DAVERAGE will be removed if D is a function of the average for AVERAGE. Second, the database function of the list Contained in the Excel database function and its application as follows:  Figure 1 Third, the meaning of the parameters of the database function
function as a result of the database have the same three parameters, so I will be the first to introduce a number of parameters of such function. And then specific examples to illustrate the application of the database function. Grammatical form of such functions for the function name (database, field, criteria). Database for data on the composition of the list or database of the range. Contains a set of database is a list of related data, including records related to the conduct of information, and as a field that contains data. Data list contains the first line of the sign of each column. Field used to designate the function of the data columns. Data in the list of data columns must have the logo of the first line. Field can be text, that is, with quotation marks at both ends of the signs, such as "the use of the number of years" or "production"; In addition, Field data can also represent data columns list the number of positions: 1, said first column, 2 that the second column , and so on. Criteria for a group of conditions contained in the given range. Criteria specified for the parameters of any region, as long as it contains at least one out signs out signs and set the conditions for the bottom of the cell. |
