Create a New Function to Shorten Your Formulas using LAMBDA Function
This video shows how to use the LAMBDA function in the Name Manager to create new functions in Excel. This allows you to use the same function in different worksheets so that you do not have to re-wrte the same formula every time.