ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Functions for manipulating arrays (https://www.excelbanter.com/excel-discussion-misc-queries/159385-functions-manipulating-arrays.html)

Alan Beban[_2_]

Functions for manipulating arrays
 
After a couple of years of neglect I have done some housekeeping on the
file of Array Functions at http://home.pacbell.net/beban. I added a
function for converting a 1 row two-dimensional array into a
one-dimensional array (without the limitations of the traditional
methods using the built-in TRANSPOSE or INDEX function), fixed a handful
of bugs, and made the functions much more coherent in their treatment of
1-based and 0-based arrays.

If any of you regularly use the functions, you might want to redownload
the file.

As always, any constructive comments or suggestions are welcome.

Alan Beban


All times are GMT +1. The time now is 01:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com