Uploaded October 2024 | Updated November 2026, 1 day ago
In this video, Iβll show you how to group values based on unique values using MAP, LAMBDA, TEXTJOIN, and FILTER functions. This is useful if you want to collect related values and display them as a single comma-separated string.
β± Time Stamp
00:00 Intro
00:39 Building the solution
02:15 Bonus Tip ARRAYTOTEXT
03:15 Error with Spill Array
03:45 Use Excel MAP and LAMBDA Function
05:46 End
--------------------------------------------------------------
π Download Link
excelexciting.com/use-excel-map-and-lambda-function-to-group-values
--------------------------------------------------------------
π Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
π£ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family π¨βπ©βπ§βπ¦ so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
π ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
ππ» Like Facebook Page :
facebook.com/ExcelExciting
π₯Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #map #lambada #filter #textjoin
In this video, Iβll show you how to group values based on unique values using MAP, LAMBDA, TEXTJOIN, and FILTER functions. This is useful if you want to collect related values and display them as a single comma-separated string.
β± Time Stamp
00:00 Intro
00:39 Building the solution
02:15 Bonus Tip ARRAYTOTEXT
03:15 Error with Spill Array
03:45 Use Excel MAP and LAMBDA Function
05:46 End
--------------------------------------------------------------
π Download Link
excelexciting.com/use-excel-map-and-lambda-function-to-group-values
--------------------------------------------------------------
π Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
π£ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family π¨βπ©βπ§βπ¦ so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
π ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
ππ» Like Facebook Page :
facebook.com/ExcelExciting
π₯Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #map #lambada #filter #textjoin




![Extract Number & Text from a Cell in Excel | Solution 01 by Power Query
In this video we will see how can extract text and numbers from a cell in Excel, this the Solution 01 with Power Query & same is applicable with PowerBI as well.
The Solution 02 is here : https://youtu.be/iei5rMstlJ0
πwww.ExcelExciting.com
ππ» Like us on Facebook
https://www.facebook.com/ExcelExciting/
π₯Join The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
Excel Power Query for Office 365 Mac π₯ (Apple) | Phase 1
https://youtu.be/1VRrPPkMGs8
Excel Tip by the Excel Queen πΈπ»(Faraz & Leila) | https://youtu.be/6CEYKRIlppE
Easiest way to Unhide All Sheets with one line code [VBA MACRO] | https://youtu.be/cs8T8gYltvI
Excel New Version of XLOOKUP & How to use emojis π | https://youtu.be/KAdbfLrpcQ0
XLOOKUP Get the lowest value Column Name in Excel | https://youtu.be/Cbu2ZlvVfXs
***********************************************************
#PowerQuery #ExcelTips #FarazExcelMaster #ExcelTrick #MicrosoftCreators #ExcelTips #ProductivityHack #Camtasia #FarazShaikh Extract Number & Text from a Cell in Excel | Solution 01 by Power Query](https://i.ytimg.com/vi/GHQXgg2PR_k/mqdefault.jpg)



![How to Install Windows 11 on Apple M1 Pro/Max (Non-Insider & Insider)
In this video, with simple and easy steps we will learn how to install windows 11 on apple macOS Monterey, Big Sur using a virtual machine. We will be using parallels to do the step on apple mac M1 Pro/Max Macbooks. Note that this installation demo is applicable only for that MacBook with an Apple Silicon M1 Pro/Max ARM64 chipset. The steps to install windows 11 insider on M1 Pro/Max machine are easy steps.
β± Time Stamp
00:00 Intro
00:20 Install Virtual Machine Apple Mac M1 Pro
01:25 Get Windows 11 (Insider & Non-insider)
02:20 Download Windows 11 Insider for Apple M1 Pro/Max
04:10 Install Windows 11 for Apple M1 Pro/Max
06:09 Working Windows 11 on M1 Pro Macbook
06:45 Add the VM already Installed
07:20 Side by Side View Windows Insider & Non-Insider
07:51 Testing Excel for Windows 11 on M1 Pro Macbook
09:13 End
π Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
- Resources: https://excelexciting.com/resources/
- Buy Parallels for Mac: https://prf.hn/click/camref:1011lkbW8/creativeref:1100l33242
π£ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family π¨βπ©βπ§βπ¦ so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
Register Windows Insider Program: https://insider.windows.com/en-us/
Download Windows 11 VHDX File: https://www.microsoft.com/en-us/software-download/windowsinsiderpreviewARM64
π https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
ππ» Like Facebook Page :
https://www.facebook.com/ExcelExciting/
π₯Join The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
Extract Multiple Matching Records
https://youtu.be/pTVxxaZQx24
Learn how to use Microsoft Flow / Power Automate
https://youtu.be/HQyxnPYW9Jc
NON-VBA Solution Convert Number to Words In Microsoft Word [mac & windows]
https://youtu.be/W1Ghyp6Rla0
Hindi-Convert Number to Words In Microsoft Word [mac & windows]
https://youtu.be/mWmgbU97ZUs
***********************************************************
#M1PRO #M1MAX #M1 #APPLE #APPLESILICON #ExcelExciting #MicrosoftCreators #ProductivityHack #MadeWithCamtasia How to Install Windows 11 on Apple M1 Pro/Max (Non-Insider & Insider)](https://i.ytimg.com/vi/H62E173CzBo/mqdefault.jpg)

![How to use Power Automate (Microsoft Flow)?
In this video we will learn how to use Power Automate (formally know as Microsoft Flow). Power Automate is cloud base technology it enables everyone to build secure workflows with a no-code guided experience and cloud-based data loss prevention, identity, and access management services. Automate time-consuming manual tasks, giving you more time to focus on strategic, high-value opportunities.
00:00 Introduction
00:42 What is Power Automate/Microsoft Flow ?
01:21 Ways to access Power Automate ?
02:21 Power Automate Environment.
02:44 Template Gallery in Power Automate?
03:32 What are connector in Power Automate?
04:09 What are connection in Power Automate?
04:25 What is AI Builder in Power Automate?
04:41 Types of Flow in Power Automate?
05:15 How to create a flow in Power Automate?
05:25 How the flow work in Power Automate?
05:33 What is a trigger in Power Automate?
05:38 What is a action in Power Automate?
06:14 Type of triggers in Power Automate?
06:47 Example 01 to create flow using instant flow in Power Automate?
10:13 Edit flow in Power Automate?
11:42 How to Run flow manually in Power Automate?
12:30 Accessing connectors in Power Automate
13:05 View all created flows in Power Automate
13:37 End Screen
π Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
π£ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
π https://www.ExcelExciting.com
Connect to our forums feel free to ask for queries & answer them
https://excelexciting.com/forums/
ππ»Faraz Shaikh - Excel Master
https://www.facebook.com/ExcelExciting/
π₯Join the Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
DISCLAIMER: The Talking Emoji If any resemblance with any person, living or dead, is purely coincidental. There is absolutely no intention to hurt any person or group of persons or any section of society through this video. This video is created to impart my understanding of a particular subject for viewers in an easy and fun way.
***********************************************************
You can check the following videos as well
Create Dynamics Flowcharts by connecting EXCEL to VISIO
https://youtu.be/xfIPFiAxQcQ
Create Organizational & Business Flowcharts Linked to Excel
https://youtu.be/Cor1mixgotY
NON-VBA Solution Convert Number to Words In Microsoft Word [mac & windows]
https://youtu.be/W1Ghyp6Rla0
Trick to Create A Data Entry Table In Power Query for Excel
https://youtu.be/bHPrRbcw6f0
***********************************************************
#FarazShaikh #ExcelExciting #PowerAutomate #PowerAddicts #ProductivityHack #MadeWithCamtasia #MicrosoftCreators How to use Power Automate (Microsoft Flow)?](https://i.ytimg.com/vi/HQyxnPYW9Jc/mqdefault.jpg)