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,""))
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))
