Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
(1) has a number of conditions of a separate If a column has two or more filter conditions, it can be directly in the line of type in all conditions in order from top to bottom. For example, the above examples show that the conditions of the region, "species" column contains "apple" or "pear" line. (2) with a single multi-column conditions 2 or more To find out the data to meet the individual conditions, the conditions of the region in the same line, type all of the conditions. For example, the following example shows all of the conditions of the region in the "high" out of more than 10 and "yield" more than 10 rows of data.
To find or meet a condition of another data, in terms of different regions of input line conditions. For example, the above examples show that all the conditions of the region in the "high" out of more than 10 rows of data. (4) 2 with one of the two groups To find the conditions to meet the two groups (each group of conditions includes conditions for multi-out) one of the data, please type in all line conditions. For example, the following conditions for the region will show all the "species" column contains "apple" and "high" more than 10 rows of data, but also show the "cherry tree" and "the use of the number of years" line more than 10 years.
To find the conditions to meet the above two lines, marked out by the same multi-out. For example, the above examples show that the conditions between the region between 10 and 16 level. (6) the results will be used as a condition of the formula Excel can be formula (formula: a series of cell values, cell references, name, or a combination of operators can generate new value. Formula always equal sign (=) to start.) As a condition of the calculation results used. Using the formula to create the conditions, do not sign will be listed as a condition tag to use, the conditions of tags should be home empty, or use the list of China-Africa signs marked out. For example, the following conditions shown in column C region, its value is greater than range C7: C10 line average. = C7> AVERAGE ($ C $ 7: $ C $ 10) It should be noted that the conditions for the use of the formula must be used to invoke the relative sign out (for example, "high"), or to quote the first record of the corresponding field. Formula all the other cited references must be absolute and must be the formula to calculate the results of TRUE or FALSE. Example of this formula, C7 cited a list of the first data record (line 7) of the field (column C). Of course, we can use the formula set out in the logo to replace the relative cell reference or regional name. When Microsoft Excel in the cell that contains the conditions to display the error value # NAME? Or # VALUE!, You can ignore these errors because they do not affect the selection list. The Microsoft Excel data in the calculation are not case sensitive. |
