These six tools are designed to analyse and record particular characteristics about a data list in Excel. For access to these functions see the List Analysis Menu and the Audit Tools Shortcuts. The characteristics cover

• the presence of duplicate values in a field
  
• the existence of records containing a particular string pattern in a field - Similar Strings
  
• the presence of gaps in a numeric series
  
• the presence of approximately equal values in a numeric series
  
• the existence of records containing numbers bigger or smaller than a critical value
  
• the current order of a record series
  

In general, the List Analysis functions mark the records in a list as 1 for TRUE (meets the criteria of the analysis) or 0 for FALSE.

The main exception to this rule is the analysis of GAPS in a numeric series.

For each type of analysis, a cryptic but unique description is provided as a header to the analysis column and acts as an audit trail to the work undertaken. The audit trail header always begins with the letter reference of the column (or field) being analysed.

Remarks

The ACBA software identifies a list by examining the range of data around the active cell. Always place your cursor on a cell within the list

Several of the List Analysis functions need the list to be in ascending order to compute. You are always given the opportunity to mark the original order before proceeding.

You may also mark the order of your list at any time during the analysis.

None of the List Analysis processes will compute if the column (or field) contains #Error values.

See also

User Tools