ArrayTools is a Project that allows easy data manipulation when working with Arrays and Collections in VBA (regardless of host Application). Operations like sorting, filtering, converting, reversing, ...

When the filtered set has multiple records, you might want to sort the results using SORT () How to add the SORT () function in Excel The SORT () function is another new dynamic array function.

An algorithm to address the shortcoming of Bubble Sort.The short coming of bubble sort is that it is inefficient for large dataset and provides more execution time. The backtracking variable is used ...