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. |
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) |