There are a number of different ways you can sort an array.

Excel Sort

Excel's sorting is by far the fastest.

Bubble Sort

The Bubble sort is reasonably fast with small arrays but for larger arrays (> 5,000) forget it !!

Counting Sort

Quick Sort

The Quick Sort is good but if the array is almost sorted then forget it.

Word Sort

You can use the following line to sort an array in Microsoft Word

WordBasic.SortArray (arArrayName) 

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext