LAMBDA function in Excel
Excel Tips and Tricks

LAMBDA Function in Excel with Example

In this article, you will learn how to use the LAMBDA Function in Excel with Example. LAMBDA function is used to create the custom function with a friendly name so that you can re-use them in the entire workbook.

 

 We have used here to two examples to create a re-useable function

 

1: Top_Find:

We have created Top_Find to find the top category by the numbers like – Sales, Marks, etc. we have used below LAMBDA Function then create created a name (Find_Top) in Name Manager

 

=LAMBDA(Whole_Range,Number_Range,Top_Count,FILTER(SORT(Whole_Range,2,-1),RANK(Number_Range,Number_Range)<=Top_Count,""))

 

Top_Find Formula
Top_Find Formula

 

2: Weekday and Sunday List:

 

Another function, we have created Weekday_List and Sunday_List between two dates-

 

Weekday_List:

=LAMBDA(Start_Date,End_Date,FILTER(SEQUENCE(End_Date-Start_Date+1,,Start_Date,1),WEEKDAY(SEQUENCE(End_Date-Start_Date+1,,Start_Date,1),2)<=5))

 

Sunday_List:

=LAMBDA(Start_Date,End_Date,FILTER(SEQUENCE(End_Date-Start_Date+1,,Start_Date,1),WEEKDAY(SEQUENCE(End_Date-Start_Date+1,,Start_Date,1),2)=7))

 

Weekday and Sunday List Formula
Weekday and Sunday List Formula

Watch the step-by-step video tutorial:

Click here to download the practice file

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com