I'm not sure this is the best approach, but it's what I know and it should work.



Presumably you have a limited number of values possible in column A.

If so, you could build an array in a seperate worksheet.

DDD 1
TTT 2
AAA 3
FFF 4
GGG 5

Then you could reference that array with =VLOOKUP(A:A,arraysheet!A:B,2,FALSE) in an extra column in your main sheet to generate a column to sort by.


AAA 123 3
FFF 111 4
GGG 456 5
DDD 654 1
AAA 775 3
FFF 986 4
TTT 777 2


Hope that helps.