Using Array Functions and UDFs

Most of my spreadsheets use User Defined Functions (UDFs), and these often return an array of results, rather than just one value, and need to be entered as an array function.  These things are not difficult to use, but for those not familiar with them they can be off-putting, so the two links below present an overview of using array functions and UDFs.  Please leave a comment if anything is not clear.

Using Array Formulas

Using UDFs – Continuous Beam Example

Finally, many of the posts here form series that grow over months or even years.  Always have a check at the end of each post for “ping-backs” from more recent posts at this blog, where the topic will be developed further and/or new versions of spreadsheets may be published.

11 Responses to Using Array Functions and UDFs

  1. Pingback: Beam actions and deflections, 3D or 2D | Newton Excel Bach, not (just) an Excel Blog

  2. Pingback: Dynamic sorting with Excel, VBA, and Python | Newton Excel Bach, not (just) an Excel Blog

  3. Pingback: Dividing shapes into layers | Newton Excel Bach, not (just) an Excel Blog

  4. Pingback: Reinforced Concrete – ULS capacity under combined axial load and biaxial bending | Newton Excel Bach, not (just) an Excel Blog

  5. Pingback: Range tips | Newton Excel Bach, not (just) an Excel Blog

  6. Pingback: More on Regular Expressions | Newton Excel Bach, not (just) an Excel Blog

  7. Pingback: Working with array functions | Newton Excel Bach, not (just) an Excel Blog

  8. Pingback: Getting concrete shrinkage right | Newton Excel Bach, not (just) an Excel Blog

  9. Pingback: Reinforced Concrete Moment Curvature – Development over time | Newton Excel Bach, not (just) an Excel Blog

  10. Pingback: Solving non-linear equations with two or more unknowns – 2 | Newton Excel Bach, not (just) an Excel Blog

  11. Pingback: Automating Goal Seek with RC Design Functions | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s