From the course: Excel: Creating Custom Functions with LAMBDA

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Manage LAMBDA output

Manage LAMBDA output - Microsoft Excel Tutorial

From the course: Excel: Creating Custom Functions with LAMBDA

Start my 1-month free trial Buy for my team

Manage LAMBDA output

“

- [Instructor] Lambda functions can return more than one value. They can be in rows, in columns, or in arrays. In this movie, I will show you four functions that you can use to manage output from Lambdas that return multiple values. My sample file is 05_07 manage output and you can find it in the chapter five folder of the exercise files collection. I have two sets of values that I work with in this movie in the range B3 to D4. I have a number of randomly selected varieties and then I will perform other operations wrapping values into arrays using columns or rows in the table here from A7 through A13. But I'll start working with the values here in my upper range. My goal is to output this data as a single row. And what I want Excel to do is to take the first row of data, so that would be row three and then to the right of it, use the data from row four of the worksheet. So I'll click and cell G2, type equal. And the…

Contents