Generates a list of cells containing numeric values that have been formatted as text. This will also include values that may look like a number, depending on the font and formatting. For example, a value of 'L23' may look like the number '123' depending on the font that is used.
Generates a list of cells containing formulas that start with a '+' character. For example, a formula such as: '=+B25' is ...
Generates a list of cells containing formulas that start with a '-' character. For example, a formula such as: '=-B25' is ...
Generates a list of cells containing formulas with errors. On the spreadsheet, Excel will show the value of these cells as ...
Generates a list of cells containing formulas with nested IF() statements. This is an IF() statement inside of another IF() ...
Generates a list of cells containing numeric values that have been formatted as text. This will also include values that ...
Generates a list of cells containing text that looks like a formula (starts with an equals sign), but is formatted as text ...
Generates a list of cells containing unique formulas. Unique formulas are formulas that exist only once within the workbook, ...
Generates a list of cells that are not blank, and the foreground and background color have been formatted to the same color. ...
Generates a list of non-formula cells with a numeric value. For example, a cell with a constant value of '27.5' would be ...