Tools for the Analysis of Spreadsheets and Data Lists 
Getting Started 
About ACBA Tools Approaches to Number Extraction Sharing Results ACBA Functions Menu Audit Tools Menu List Analysis Menu List Comparison Menu Spreadsheet Data Lists Menu Random Sampling Menu Numbers in Strings Menu Number Arrays in Strings Menu Audit Tools Shortcuts Loading Audit Tools About Add-Ins Loading Add-Ins Help and Resources User Manual On-line help User Forum ACBA (UK) LTD Website User Tools List Analysis Duplicates Similar Strings Gaps in Number Series Close (approximate) values Big/Little values Current Order List Comparison Missing Records Changed Values Matching Records Create Key Field Spreadsheet Data Numbers Formulae Errors Shapes Text List Management Numbers inside Strings - Form Based User Forms vs Worksheet Functions Extract Number From Beginning or End of string From Position in string After string Pattern Nth integer in string Miscellaneous Functions Sum of integers in string Count of integers in string Number Arrays in Strings - Form Based Extract from Number Array How Many Number Groups? Report Position Details Array Min/Max Details Array Criterion Analysis Number of Items Matching Criterion Position of Nth Item Matching Criterion Random Sampling Prepare New Data and Sample Prepare new Sample from Existing Data Review Data Descriptions Sampling Electronic Populations Data Cleansing Worksheet Functions or Formulae About Worksheet Functions Approximately Equal Fixed Permissible Variance Percentage Permissible Variance Comparing Numbers in Two Strings Without Order With Order Numbers inside Strings Extracting Numbers Beginning of String - Integer Beginning of String - Decimal End of String - Integer End of String - Decimal From a Position within a String After a character group within a string Nth Digit in a string Extracting Information Count of Digits in a String Sum of Digits within a String Number Arrays in Strings Extracting information from a number array At Array Position Number Value Start Position in String String Length of Number Character before Number String Character after Number String Additional Information Maximum Value in Number Array Minimum Value in Number Array Maximum String Length in Number Array Minimum String Length in Number Array Number Value at String Position Describing contents of a number array Count of Items in Number Array Count of items Matching Criterion Match Number Value Match Start Position Match String Length Position of Nth Matching Item Nth Number Value Nth Start Position Nth String Length Maximum Number Value Minimum Number Value Maximum String Length Minimum String Length