Alphabetizing

How do you alphabetize an array using a formula? I'm looking for something similar to the =LARGE() function, where you set the array and order number. I'm aware there is a sort button, but I prefer to use a formula for this worksheet. Any help is greatly appreciated!

Hi

Don't know of any standard formula but you can use standard formulas this way.

Say your unsorted data is in the range A1:A6
B1: =COUNTIF($A$1:$A$6,"<"&A1)
Copy down to B6
C1: =INDEX($A$1:$A$6,MATCH(SMALL($B$1:$B$6,ROW(A1)),$B$1:$B$6,0))
Copy down to C6.

This will sort the data from A1:A6 in ascending order. If you want descending order, then change the "<" in the formula in column B to ">".

If that doesn't suit, then you could build your own function to perform the sort.

HTH

rylo

Many thanks!!!! Works great