Skip to content
Archive of posts tagged function

A JoinAll function

Based on a discussion on the mrexcel.com website of Harlan Grove’s AConCat function, I wrote a join (or concatenate) function that works with a scalar data type (a number, a string, or a boolean) as well as complex data types like a range, an array, a collection, or a dictionary. It also accepts an arbitrary […]

Using the Excel MATCH Function for a Linear Search and a Binary Search