The term "lifting" refers to an array calculation behavior in Excel formulas. When you give an array to a function not programmed to accept arrays natively, Excel will "lift" the function and call it multiple times, one time for each value in the array. The result an array with the same dimensions as the input array. Lifting is a built-in behavior that happens automatically.
The example shown illustrates what happens if you call the LEN function on the range C5:C7, which contains three values. LEN isn't programmed to handle arrays natively, so LEN is run three times, once for each value in an operation like this:
Notice the result is a vertical array with three values, just like the source range.
Dealing with multiple results
When lifting occurs in a formula, there will be multiple results, and these need to be catered for.
In the example above, because LEN returns three separate values in an array, we need handle the output with a function that can work with arrays. One option is to calculate a total character count in the range C5:C7 using SUMPRODUCT:
An array in Excel is a structure that holds a collection of values. Arrays can be mapped perfectly to ranges in a spreadsheet, which is why they are so important in Excel. All Excel formulas that use a worksheet reference are working with arrays. In...
The term "pairwise lifting" in Excel refers to a special case of "lifting" – a built in calculation behavior whereby functions that don't handle arrays natively are "lifted" and called once for each value in an array, returning in turn an array...
An array formula performs an operation on multiple values instead of a single value. The final result of an array formula can be either one item or an array of items, depending on how the formula is constructed. To work correctly, many array...