View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Define alphabetic sequence to sort by

You could add the sequence to a list in ToolsOptionsCustom Lists.

The DataSortOptionsFirst Key Sort Order.

Pick from dropdown.

Although I don't know what the ? marks signify.


Gord Dibben MS Excel MVP


On Wed, 9 Jul 2008 01:04:01 -0700, Simon
wrote:

Hello,

I would like to sort a column of words according to an alphabetic sequence
that I define. For example, a sequence could be a, ?, i, ?, u, ?, ?, ?, e,
ai, o, au, k, kh, g, gh, ?, c, ca, j, ja, ñ etc. The above sequence is part
of the alphabet of a certain transliteration standard. Anyone know how to do
this?

Thank you.