View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Define alphabetic sequence to sort by

You could assign a sequence number to each of those extracts in a helper
column, and then sort on the helper column as the first sort key and the
word as the second sort key. Put your list somewhere (e.g. starting in X1)
in the order you want to sort. Then in your helper column you could have a
formula like this:

=IF(ISNA(MATCH(LEFT(A1,1),X:X,0)),MATCH(LEFT(A1,2) ,X:X,0),MATCH(LEFT(A1,1),X1:X,0))

This matches on the first two characters if there is no match on the first
character and returns the appropriate number, assuming your words are in
column A. Copy the formula down, then sort on both the helper column and on
column A.

Hope this helps.

Pete

"Simon" wrote in message
...
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, a, i, i, u, 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.