VBA Array compression algorithim to compress single and two dimensional arrays. Its a very fast algorithm and is an essential item in your toolkit if your doing Excel VBA programming. t also includes a very usefull algorithm for removing empty rows from a single of two dimensional array -very useful as a data filter tool within your code. Instructions on how to use the class module will be e-mailed to you. It works with all versions of MS Office that support VBA -it requires no installation or object library references as its a class module that you can import straight into your VBA class modules (It's essentially a txt file). (It is assumed that you know basic VBA programming -it is designed to run within MS Office Applications only.) Example of how you would use it: To use the module you type in the following within your code module. Dim aryData() As Variant Dim aryOutput() As Variant Call clsAryProcessing.fncArrayCompressByKeys(aryData(),aryOutput() ,0,”G1”,2,3) In this instance we have told the system to group on Dimension 0 and to sum on dimensions 1 and 2. The Following example shows you the result of a two dimensional array aryData(0,0)= “John” aryData(0,1)= “Tool Dept” aryData(0,2)= 100 aryData(0,3)= 22.60 aryData(1,0)= “Peter” aryData(1,1)= “Tool Dept” aryData(1,2)= 30 aryData(1,3)= 15 aryData(3,0)= “Peter” aryData(3,1)= “Sales Dept” aryData(3,2)= 30 aryData(3,3)= 15 This will then return the data compressed in aryOutPut() Results: aryOutput(0,0)=‘Tool Dept” aryOutput(0,1)=130 aryOutput(0,2)=37.60 aryOutput(1,0)=‘Sales Dept” aryOutput(1,1)=30 aryOutput(1,2)=15