Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Define alphabetic sequence to sort by
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort by month out of sequence | Excel Discussion (Misc queries) | |||
Can you sort your sheet tabs in your workbook to ascend alphabetic | Excel Discussion (Misc queries) | |||
how can I set up an alphabetic sequence? | Excel Discussion (Misc queries) | |||
How do I autofill an alphabetic sequence? (AAA, AAB, etc.) | Excel Discussion (Misc queries) | |||
How to autofill excel with an alphabetic sequence (aaa, aab, etc.. | Excel Discussion (Misc queries) |