Sort Formula for TEXT

[Aaron]

Thanks Bernie,

This is working great with numbers. However, I'm trying
to sort a list of names (TEXT). I have tried to use
the "code" function to determine the letter code, and got
the list working to a point that it will sort by the first
letter of the name. The tie breaker ceased the further
sorting of the next letter and so on... Please see
example...


Col.A Col.B Col.C Col.D Col.E Col.F
3 USA 85 85 CAR
4 UK 85 85 CANADA
5 USA 85 85 USA
1 CAR 67 67 UK
2 CANADA 67 67.00000001 USA

With A1
=RANK(D1,$D$1:$D$5,1)

B1
Data to be sorted

C1
=IF(ISERROR(CODE(LEFT(B1,1))),"",CODE(LEFT(B1,1)))

D1
=C1+ROW()*0.000000001

F1
=VLOOKUP(ROW(),$A$1:$B$5,2,FALSE)

And everything copied down to ROW 5.


Please advise if it is possible to further sort the name
so then the outcome in Col.F would be:

CANADA
CAR
UK
USA
USA

Your assistance is very much appreciated.

Thanks again,
Aaron

 

[Fred Smith]

You've lost us. Why can't you simply sort on Column F?