Modern Excel Formulas

Pairwise lifting

Modern Excel Formulas Lessons Pairwise lifting

Summary

In this video, we look at Pairwise Lifting which expands on the lifting concept presented earlier.

EXAMPLE FILE: Modern Excel Formulas – Start.xlsx > Example

Pairwise lifting occurs when multiple scalar arguments are provided with multiple values in a range or array. Calculation occurs based on the relative position of the values.

Function arguments calculate based on relative position.

Lessons

  1. Welcome & introduction
  2. Download the example files
  3. From ranges to arrays
  4. Arrays & array functions
  5. Lifting
  6. Example (Part #1)
  7. Broadcasting
  8. Example (Part #2)
  9. Pairwise lifting
  10. Example (Part #3)
  11. Boolean logic
  12. Example (Part #4)
  13. Variables (LET Function)
  14. Example (Part #5)
  15. Lookup example
  16. Wrap up
  17. Feedback