-
Join Two Ranges Or Arrays Of Data Together Using This LAMBDA Function
You may have found yourself wanting to join two arrays together in Excel. This function will quickly append and optionally deduplicate two single-column arrays or ranges of data. This is done with the LAMBDA shown above, which you can define in Excel’s Name Manager with the name ARRAYUNION. It accepts 3 arguments: array_a – a single-column array or range array_b – a single-column array or range keep_duplicates – a TRUE/FALSE value indicating whether to keep or remove duplicate values after appending array_b to array_a It couldn’t be simpler to use: The approach uses MAKEARRAY to create an array that…