Generates a list of cells containing array formulas. On the spreadsheet, Excel will show arrays formulas with surrounding braces such as: '{=SUM(G3:G12*H3:H12)}'
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 ...
Generates a list of cells containing formulas that produce a date/time value. For example, the formula: '=NOW()' will produce ...