Hey Biff,
The formula only gave me a #Value! error as an array and a #N/A! error
for a non-array. I'll try to tweak it, but I don't know if I'll get it
to work. I'll keep you posted.
Biff Wrote:
Hi!

Here's one way but it will only sort based on the first character of
the
text entry.

Assume the text entries are in the range A1:A20. To extract those
entries
sorted in ascending order, enter this formula as an array with the key
combo
of CTRL,SHIFT,ENTER:

=INDEX(A$1:A$20,MATCH(SMALL(CODE(UPPER(LEFT(A$1:A$ 20,1))),ROW(1:1)),CODE(UPPER(LEFT(A$1:A$20,1))),0) )

Copy down as needed.

To sort in descending order, in the formula change SMALL to LARGE.

Biff

"malik641"
wrote in
message ...

Anybody???


--
malik641

------------------------------------------------------------------------
malik641's Profile:
http://www.excelforum.com/member.php...o&userid=24190
View this thread:
http://www.excelforum.com/showthread...hreadid=381859



--
malik641
------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=381859