In this video, I will show you how to use the REDUCE function in Excel. Reduce is one of the harder functions, and this video covers a lot of practical examples that will make it easy for you to know how the Reduce function works and when to use it. Reduce is a Lambda helper function that is available in Excel with Microsoft 365 (Windows and Mac) and Excel on the Web. Lambda Function Video: ➡️ Download File: 00:00 Intro 00:20 Understanding the REDUCE Function 06:03 Conditional SUM using REDUCE 08:58 Conditional SUM with Alphanumeric Data 14:21 Conditional Concatenation 19:11 Split Text in Both Directions 23:00 Extracting All Unique Words 26:06 Multiple Find and Replace ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - ✅ Free Excel Course (Basic to Advanced) - ✅ Free Dashboard Course - ✅ Free VBA course - ✅ Free Power Query Course - ✅ Best Excel Books: Subscribe to get awesome Excel Tips every week: #Excel #ExcelTips #ExcelTutorial #SumitBansal