| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract segments of an array
My array of strings is already sorted from A to Z:
mySort(1) = "apples" mySort(2) = "apricot" mySort(3) = "banana" mySort(4) = "beans" mySort(5) = "bread" mySort(6) = "donuts" '... etc, etc.. mySort(38) = "zuchini" Is there an easy function that can copy any alphabetical segment of the array into a new array? For example, if I give the function input "B", it should create this new array: myarray = Array("banana", "beans", "bread") Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to extract data from an array | Excel Programming | |||
| Extract multiple values from array | Excel Discussion (Misc queries) | |||
| Extract a column/row from a 2-D array | Excel Programming | |||
| How do I extract a single value from the linest array result? | Excel Worksheet Functions | |||
| How do I extract hyperlink as text from an array of hyperlinks? | Excel Worksheet Functions | |||
Threaded Mode
