Best I can offer is this
1/. Create a lookup list of the Diacritics you need to ignore/replace.
I have done this in Sheet("Lookups")
Make this a dynamic named range "Diacritics"
Refers to:=
2/. Put this UDF in a standard VBa module
3/. With Sheet1 Columns("C:D") These can be hidden with the grouping +/- icon)
In C1
In D2
Drag/Fill Down
4/. Sort Columns("A:D")
Sort by:=Column D Order:=Smallest to Largest
Sort by:=Column C Order:=A to Z
Sort by:=Column B Order:=A to Z (If required)
See the attached
Bookmarks