sorting in specific order

[nth34]

hi guys,

i have a lots of data in the same column,

and i wanna sort them in specific order

for example

A
A12
B
B23
C
D
E
F12
G
H
I
J1234


and the expected sorting order is :

D
E
F
F12
A
A12
......

in specifically, i have dynamic numbers behind the text.. may be added one day, and i cant set up a sorting just by adding the custom sorting in excel.
Any thoughts on this sorting?

Happy Weekend!

[azumi]

Perhaps something like this?

[nth34]

my case is i have specific ranking order... not ascending or descending... thats the most difficult part for me...
for example..
a
b
c
d
e
f

my sorting order may be like
f
a
b
c
d

and sometimes

f
f12
aa12
a1234
c
d23
d345

[Glenn Kennedy]

Since this appears to be TOTALLY random, can you please post some REAL examples (before and after) so that we can discern what patterns (if any) are present - and also preferably in an Excel sheet?

[Glenn Kennedy]

One way, based on your first post's "examples", might be the use of a helper column and a lookup table..

[nth34]

Sorry for the misunderstanding..
I should list much more details.
Sorry guys,

I have a list of data that have to follow the rank.
For example.

LIST:
Daddy
Mum
Child
Pet

And my data in random:
A
B
Child
Pet
Mum
Dad

And my expected result is
Daddy
Mum
Child
Pet
A
B

But the most inconvenience part is:
daddy123
daddy456
mum990
mum
child
child1

and the numbers after text would be dynamic.
and i dont know how to sort them accordingly.
as in vba, i can specific the ranking of each "daddy""mum""child", but once there are dynamic numbers behind the text, i dont want to amend the code for each time..
for a few dozens of data are fine, how about thousands, millions, lol

i cant amend the code each time.
Is there any possible solution to handle this kind of condition?

Best Wishes,
Matt

[Glenn Kennedy]

I have a sinking feeling about this when I see:

daddy123
daddy456
mum990
mum
child
child1

Two cases (Daddy and child) where the numbers are in ascending order and one (mummy) where the opposite is true. If that's a mistake: take a look at the sheet. Otherwise, I think you're going to HAVE to explain what's REALLY going on and show us some REAL data and the logic behind the sort order.

[nth34]

I have a sinking feeling about this when I see:

daddy123
daddy456
mum990
mum
child
child1

Two cases (Daddy and child) where the numbers are in ascending order and one (mummy) where the opposite is true. If that's a mistake: take a look at the sheet. Otherwise, I think you're going to HAVE to explain what's REALLY going on and show us some REAL data and the logic behind the sort order.

Sorry bro, its my mistake.
you are right!thank you so much for the solution.
Its quite indirect in excel.

Thank you so much!

[Glenn Kennedy]

You're welcome and thanks for the Reputation...