Quote:
Originally Posted by Hate-Excel-Need
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.
|
Add a custom list:
for excel 2010:
Fille\Excel Options\Advanced\Edit Custom List