I'm glad it helped.

To reiterate the UDF is driven by the QSortInPlace code (this does the hard work) and is something I use quite frequently for this type of exercise.

You can find more info. on this routine from the authors website: http://www.cpearson.com/Excel/SortingArrays.aspx
(see also: http://www.cpearson.com/Excel/VBAArrays.htm)

The same can be achieved without need for VBA but the UDF makes things a lot cleaner from the worksheet point of view.