Part of the Macaulay spreasheet presented in recent posts required the formation of a list of points along a beam where the functions needed to be evaluated. These are: The support points, the changes of cross section, and the output points specified by the user. These points are in three separate arrays which must be combined into one, maintaining the correct order from left to right, and without duplication of any point.
I have now converted the function that performs the combination so that it can also be used as a User Defined Function (UDF) in a worksheet. The result (including full open source code) may be downloaded from: http://www.interactiveds.com.au/software/CombineArray.xls
The function works with single column or multiple column arrays, exmples of which are shown in the screenshots below:
Note that CombineArray works as an array function, and must be entered with the correct procedure:
- Enter the function
- Select the entire output range, as shown shaded blue above
- Press F2 to enter Edit mode
- Press Ctrl-Shift-Enter to enter as an array function.