I had a need recently to be able to take arrays of data with unpredictable orders and compare them. However, the order of the data is irrelevant and unpredictable. So, how to do it? I wrote two things: One to compare the arrays, and a bubble sort to sort the values. Elementary programming, yes, but handy nonetheless. Private Function ArrayCompare(ByRef vArray1, ByRef vArray2, ByVal lCompareType) Dim blnResult 'As Boolean Dim vTemp1 'As Variant Dim vTemp2 'As Variant 'We will assume the arrays are...