Hello Melissa,

http://www.bplumhoff.de/software/sort_chapter.xls

is a sample spreadsheet with a UDF in it which solves this.

HTH,
Bernd