Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sort order for characters & symbols - does anything follow z?
Hi! I was just wondering if anybody knows of a character that comes AFTER z
in the sorting order? Basically, I have a name defined list of members of staff, which I use as a dropdown menu for entering data into certain fields. However, we take on new staff all the time, and so I will need to be adding names to that list all the time. Because this group is also used as a lookup vector, it needs to be in alphabetical order too (and I'd prefer it that way anyway). I did look at the "Update Multiple Validation Lists" file at http://www.contextures.com/excelfiles.html but I'm afraid I am a novice when it comes to macros, and couldn't manage to alter the code to match the sheet names, columns etc... in my own workbook (I don't have a clue which parameters to alter or how!). So my basic method was that if I inserted new cells into the name defined range, then the cells that the name refers to should expand accordingly. E.g. if cells A1:A2 are named "list", I click on A2 and choose insert to put a new cell between the two, then my "refers to" part on the define name menu automatically changes from A1:A2 to A1:A3. The problem is this - I need to make sure that there is ALWAYS one cell below where I am inserting the new one, to make sure the range expands. If my last entry was "Young", and I then needed to add a "Zackyros", the new cell comes at the end, after the last cell, and I then need to manually go back to re-define the named range. I was hoping to add a "dummy" entry to the bottom of the list to ensure this doesn't happen, e.g. ** END OF LIST ** but all the symbols I try come BEFORE alphabetical characters. I can't find any that come after Z. If worst comes to the worst I could use zzzz END OF LIST zzzz but I thought it would be worth asking first. Can anyone solve the riddle? Many thanks in advance, Neil Goldwasser. |
#2
|
|||
|
|||
To find characters that follow z go to the character map (Start, Run, CHARMAP) and see the order of characters, for Arial ﻼ appears to be the highest, this should help your sort, but not the look, perhaps the zzzz is the better idea if users will see this. Neil Goldwasser Wrote: Hi! I was just wondering if anybody knows of a character that comes AFTER z in the sorting order? Basically, I have a name defined list of members of staff, which I use as a dropdown menu for entering data into certain fields. However, we take on new staff all the time, and so I will need to be adding names to that list all the time. Because this group is also used as a lookup vector, it needs to be in alphabetical order too (and I'd prefer it that way anyway). I did look at the "Update Multiple Validation Lists" file at http://www.contextures.com/excelfiles.html but I'm afraid I am a novice when it comes to macros, and couldn't manage to alter the code to match the sheet names, columns etc... in my own workbook (I don't have a clue which parameters to alter or how!). So my basic method was that if I inserted new cells into the name defined range, then the cells that the name refers to should expand accordingly. E.g. if cells A1:A2 are named "list", I click on A2 and choose insert to put a new cell between the two, then my "refers to" part on the define name menu automatically changes from A1:A2 to A1:A3. The problem is this - I need to make sure that there is ALWAYS one cell below where I am inserting the new one, to make sure the range expands. If my last entry was "Young", and I then needed to add a "Zackyros", the new cell comes at the end, after the last cell, and I then need to manually go back to re-define the named range. I was hoping to add a "dummy" entry to the bottom of the list to ensure this doesn't happen, e.g. ** END OF LIST ** but all the symbols I try come BEFORE alphabetical characters. I can't find any that come after Z. If worst comes to the worst I could use zzzz END OF LIST zzzz but I thought it would be worth asking first. Can anyone solve the riddle? Many thanks in advance, Neil Goldwasser. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=392849 |
#3
|
|||
|
|||
the lower case z is CHAR(122). There are two characters after it:
CHAR(142) and CHAR(158) -- Gary's Student "Bryan Hessey" wrote: To find characters that follow z go to the character map (Start, Run, CHARMAP) and see the order of characters, for Arial ﻼ appears to be the highest, this should help your sort, but not the look, perhaps the zzzz is the better idea if users will see this. Neil Goldwasser Wrote: Hi! I was just wondering if anybody knows of a character that comes AFTER z in the sorting order? Basically, I have a name defined list of members of staff, which I use as a dropdown menu for entering data into certain fields. However, we take on new staff all the time, and so I will need to be adding names to that list all the time. Because this group is also used as a lookup vector, it needs to be in alphabetical order too (and I'd prefer it that way anyway). I did look at the "Update Multiple Validation Lists" file at http://www.contextures.com/excelfiles.html but I'm afraid I am a novice when it comes to macros, and couldn't manage to alter the code to match the sheet names, columns etc... in my own workbook (I don't have a clue which parameters to alter or how!). So my basic method was that if I inserted new cells into the name defined range, then the cells that the name refers to should expand accordingly. E.g. if cells A1:A2 are named "list", I click on A2 and choose insert to put a new cell between the two, then my "refers to" part on the define name menu automatically changes from A1:A2 to A1:A3. The problem is this - I need to make sure that there is ALWAYS one cell below where I am inserting the new one, to make sure the range expands. If my last entry was "Young", and I then needed to add a "Zackyros", the new cell comes at the end, after the last cell, and I then need to manually go back to re-define the named range. I was hoping to add a "dummy" entry to the bottom of the list to ensure this doesn't happen, e.g. ** END OF LIST ** but all the symbols I try come BEFORE alphabetical characters. I can't find any that come after Z. If worst comes to the worst I could use zzzz END OF LIST zzzz but I thought it would be worth asking first. Can anyone solve the riddle? Many thanks in advance, Neil Goldwasser. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=392849 |
#4
|
|||
|
|||
Thanks. I tried the character map thing (never seen it before) but I didn't
know what the ﻼ bit meant in your post. Yes, the users will see the list, so unless there is a nice neat symbol e.g. bullet point, arrow etc... that will come after z, it looks like I'll go with the zzzzz idea. What do I do with the character map though? Neil Goldwasser "Gary's Student" wrote: the lower case z is CHAR(122). There are two characters after it: CHAR(142) and CHAR(158) -- Gary's Student "Bryan Hessey" wrote: To find characters that follow z go to the character map (Start, Run, CHARMAP) and see the order of characters, for Arial ﻼ appears to be the highest, this should help your sort, but not the look, perhaps the zzzz is the better idea if users will see this. Neil Goldwasser Wrote: Hi! I was just wondering if anybody knows of a character that comes AFTER z in the sorting order? Basically, I have a name defined list of members of staff, which I use as a dropdown menu for entering data into certain fields. However, we take on new staff all the time, and so I will need to be adding names to that list all the time. Because this group is also used as a lookup vector, it needs to be in alphabetical order too (and I'd prefer it that way anyway). I did look at the "Update Multiple Validation Lists" file at http://www.contextures.com/excelfiles.html but I'm afraid I am a novice when it comes to macros, and couldn't manage to alter the code to match the sheet names, columns etc... in my own workbook (I don't have a clue which parameters to alter or how!). So my basic method was that if I inserted new cells into the name defined range, then the cells that the name refers to should expand accordingly. E.g. if cells A1:A2 are named "list", I click on A2 and choose insert to put a new cell between the two, then my "refers to" part on the define name menu automatically changes from A1:A2 to A1:A3. The problem is this - I need to make sure that there is ALWAYS one cell below where I am inserting the new one, to make sure the range expands. If my last entry was "Young", and I then needed to add a "Zackyros", the new cell comes at the end, after the last cell, and I then need to manually go back to re-define the named range. I was hoping to add a "dummy" entry to the bottom of the list to ensure this doesn't happen, e.g. ** END OF LIST ** but all the symbols I try come BEFORE alphabetical characters. I can't find any that come after Z. If worst comes to the worst I could use zzzz END OF LIST zzzz but I thought it would be worth asking first. Can anyone solve the riddle? Many thanks in advance, Neil Goldwasser. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=392849 |
#5
|
|||
|
|||
I think the ZZZ is the best option, it won't confuse your users (except the ones that want to know who Ms ZZZ End of File is) The map is just to display the code used to generate which character in whatever Font is currently selected, thus if you hold the Alt key and type (using the numeric keypad on the right side of your keyboard) 090 (zero-nine-zero) then release the Alt key you should produce a Z Also, check your sort, I think uppercase Z sorts after lowercase z. Neil Goldwasser Wrote: Thanks. I tried the character map thing (never seen it before) but I didn't know what the ﻼ bit meant in your post. Yes, the users will see the list, so unless there is a nice neat symbol e.g. bullet point, arrow etc... that will come after z, it looks like I'll go with the zzzzz idea. What do I do with the character map though? Neil Goldwasser "Gary's Student" wrote: the lower case z is CHAR(122). There are two characters after it: CHAR(142) and CHAR(158) -- Gary's Student "Bryan Hessey" wrote: To find characters that follow z go to the character map (Start, Run, CHARMAP) and see the order of characters, for Arial ﻼ appears to be the highest, this should help your sort, but not the look, perhaps the zzzz is the better idea if users will see this. Neil Goldwasser Wrote: Hi! I was just wondering if anybody knows of a character that comes AFTER z in the sorting order? Basically, I have a name defined list of members of staff, which I use as a dropdown menu for entering data into certain fields. However, we take on new staff all the time, and so I will need to be adding names to that list all the time. Because this group is also used as a lookup vector, it needs to be in alphabetical order too (and I'd prefer it that way anyway). I did look at the "Update Multiple Validation Lists" file at http://www.contextures.com/excelfiles.html but I'm afraid I am a novice when it comes to macros, and couldn't manage to alter the code to match the sheet names, columns etc... in my own workbook (I don't have a clue which parameters to alter or how!). So my basic method was that if I inserted new cells into the name defined range, then the cells that the name refers to should expand accordingly. E.g. if cells A1:A2 are named "list", I click on A2 and choose insert to put a new cell between the two, then my "refers to" part on the define name menu automatically changes from A1:A2 to A1:A3. The problem is this - I need to make sure that there is ALWAYS one cell below where I am inserting the new one, to make sure the range expands. If my last entry was "Young", and I then needed to add a "Zackyros", the new cell comes at the end, after the last cell, and I then need to manually go back to re-define the named range. I was hoping to add a "dummy" entry to the bottom of the list to ensure this doesn't happen, e.g. ** END OF LIST ** but all the symbols I try come BEFORE alphabetical characters. I can't find any that come after Z. If worst comes to the worst I could use zzzz END OF LIST zzzz but I thought it would be worth asking first. Can anyone solve the riddle? Many thanks in advance, Neil Goldwasser. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=392849 -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=392849 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I sort SSNs in Terminal Digit Order using Excel? | Excel Worksheet Functions | |||
How can I sort multiple months/years WITHOUT Alpha order taking o. | Excel Worksheet Functions | |||
I have two identical pivot tables with different sort order of th. | Excel Discussion (Misc queries) | |||
how do I reset the default sort order in excel xp back to blanks . | Excel Discussion (Misc queries) | |||
Need to sort dates before 1900 in proper order | Excel Discussion (Misc queries) |