One venture using non-array formulas ..

Source data assumed in A1 down

In B1:
=IF(A1="","",IF(LEN(A1)1,CODE(LEFT(A1))+CODE(MID( A1,2,1))/10^10,CODE(LEFT(A1))))

In C1:
=IF(ROW()COUNT(B:B),"",INDEX(A:A,MATCH(SMALL(B:B, ROW()),B:B,0)))
Select B1:C1, copy down to cover the max expected extent of source data.
Hide away col B. Col C returns the required auto-ascending sort.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Smibes" wrote:
Hi Mike,

The data would look something like this:

Column A Column B
1 Process Change
2 Technology People
3 Policy Policy
4 People Process
5 Change Technology

Column B would be derived by formula. If column A was numbers this would be
easy using the "LARGE" function =LARGE(A1:A5,n) in each cell in column B
(n = 1 to 5).

I hope this makes sense.

Cheers,
John