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 Strings - Approach to Analysis Similar Strings Series of Similar Strings Negative Search Criteria - a discussion 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 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 List Management and Control Managing String Series Storage vs Access Creating a String Series Categories and Groups Order within DropDown List Storage Containers Adding Series Adding a New String Series Adding a Pre-registered String Series Amending Series References within ACBA Tools Search Criteria or Lists Deleting Series An Individual Series List A Series group in a Workbook A Series group by source value All the listed String Series Managing Spreadsheet Data List Management Worksheet Functions or Formulae About Worksheet Functions Approximately Equal Fixed Permissible Variance Percentage Permissible Variance Comparing Numbers in Two Strings Without Order With Ordrer 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