Generates a list of cells containing any formula with a textual constant as part of its formula. For example, ="Hello world"
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" ...
Generates a list of cells containing array formulas. On the spreadsheet, Excel will show arrays formulas with surrounding ...
Generates a list of cells containing duplicate formulas. Duplicate formulas are formulas that are duplicated one or more ...
Generates a list of cells containing formulas that are inconsistent with its neighboring cells. For example, if a row is ...
Generates a list of cells containing formulas that do not refer to other cells. For example, the formula: '=5*2' does not ...