| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alphabetizing array items
I am trying to enter a list of items in an array. How can
I alphabetize the items (sort them) as they are entered into the array? For example, lets say I have a list of names in a worksheet from cells A1 to A4: Mike, John, Dave, Mark. As I enter these names into an array, NameArr(), I want them to be in alphabetical order, so once they are all entered, NameArr(1) is Dave. I hope this makes sense. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| transpose 1 column of 100 items to 10 x 10 array | Excel Discussion (Misc queries) | |||
| need formula to count non-zero items in an array based on a vlooku | Excel Worksheet Functions | |||
| create an array with unique items IN MEMORY | Excel Worksheet Functions | |||
| Counting items in an array | Excel Programming | |||
| Number of Items in an Array. | Excel Programming | |||
Threaded Mode
