!function_num,options,array,k!function_num,options,ref1,...!!Returns an aggregate in a list or database!is the number 1 to 19 that specifies the summary function for the aggregate.!is the number 0 to 7 that specifies the values to ignore for the aggregate!is the array or range of numerical data on which to calculate the aggregate!indicates the position in the array; it is k-th largest, k-th smallest, k-th percentile, or k-th quartile.!is the number 1 to 19 that specifies the summary function for the aggregate.!is the number 0 to 7 that specifies the values to ignore for the aggregate!are 1 to 253 ranges or references for which you want the aggregate!
find_text,within_text,start_num!Returns the starting position of one text string within another text string. FIND is case-sensitive!is ...
First make sure the Use The Query Wizard To Create/Edit Queries option is checked, if present.Next, specify a source for ...
For files in this location, both data connections defined in trusted data connection libraries and connections embedded in ...
fractional_dollar,fraction!Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal ...
function_num,options,array,k!function_num,options,ref1,.!Returns an aggregate in a list or database!is the number 1 to 19 ...
function_num,ref1,.!Returns a subtotal in a list or database!is the number 1 to 11 that specifies the summary function for ...
Generates a list of all cells that have dependent cells. Changing the value of any cell on this list would change the value ...
Generates a list of cells containing any formula with a numeric constant as part of its formula. For example, =SUM(A3:B7)*25.2 ...
Generates a list of cells containing any formula with a textual constant as part of its formula. For example, ="Hello world" ...