Custom sort depending on specific letters

[YasserKhalil]

Hello everyone
With new issue ..I hope it will be clear
I have letters (not all letters) ordered in custom order in range(A4:A11) ..which we would depend on it in the process of sort
In other words , the first letter in this list would have the priority in sort .. the first letter for example is letter "D" so all names which starts with "D" would be first and sorted of course
and so on with other letter existed in the range

As for the rest of names which are not included in the list of letters would be sorted in normal way
Generally the desired results in the attachment will clarify my issue better
Thanks advanced

[MrShorty]

You have posted this in the VBA forum, and many of your previous project have preferred a VBA solution. How much of this must be done by VBA, and how much will you tolerate done by worksheet formulas and the built in Sort utility?

The approach I would probably use for something like this would use minimal VBA and would look something like this.
1) Make the list of "out of order" letters into a lookup table

Please Login or Register  to view this content.

2) Use a lookup function to add a column to the list to be sorted. Something like =iferror(vlookup(left(C1,$A$4:$B$11,2,false),9).
3) Use the regular sort command to sort the list.
a) sort first by the helper column created in 2 (maybe column D)
b) then sort by the existing list column C.

[YasserKhalil]

Thanks a lot MrShorty for all your great help
I liked a lot your simple and effective approach it's very great
I applied your approach and everything is ok
But as you told I prefer VBA solutions ...and at the same time my original file is very complicated so I don't need to use helper columns at all ..
In your approach I had to use two helper columns ..
Generally it is very very great steps to solve the problem
I may try to interpret it to VBA steps
Thank you very much

[karedog]

Maybe :

Please Login or Register  to view this content.

[excel_bat]

Hi, this worked for me. The code also sorts the names within the chosen letters. It might need some optimization... Hope it helps!

[YasserKhalil]

Mr. Karedog
Thanks a lot for all great and awesome gifts ..it works very well with the sample file (which was in English letters) ..
I applied it to my original file in Arabic example I encountered an error
Thanks a lot for help

[YasserKhalil]

Hi, this worked for me. The code also sorts the names within the chosen letters. It might need some optimization... Hope it helps!

Thanks a lot for help
as for results I found that "Amany" was replaced with Aaa ...

[excel_bat]

Yes! I was checking that the code was sorting well. Sorry about that!

Thanks for the rep!

[YasserKhalil]

@MrShorty
When trying to apply your approach to my original Arabic file I found that "أ" and "إ" and "ا" are the same ...while I need to deal with them as different instances ..and this caused incorrect results
Hope it is clear

[karedog]

Sorry, forget to check empty member :

Please Login or Register  to view this content.

Thank you for the rep. points.

[karedog]

-- Deleted --

[YasserKhalil]

Now it is very very perfect
Thank you very much for this excellent and genius solution
Regards

[karedog]

You are welcome, glad I can help.


Regards