Combining Tables with Copilot in Excel (only UNIQUE values)

I demonstrate how Copilot in Excel helps to combine unique names from two lists using the VSTACK and UNIQUE functions. Follow along as I walk you through my process, showcasing how to use these functions to eliminate duplicates efficiently. Don't miss my upcoming live session on February 21st at noon Eastern time, where I'll be focusing on Copilot and Excel—streaming live on YouTube and LinkedIn. Thank you for watching, and have a wonderful day!

00:00 Introduction to Copilot in Excel
00:22 Setting Up the Tables
00:35 Combining Unique Names with Copilot
01:05 Manual Method Using VSTACK and UNIQUE
01:48 Upcoming Live Stream Announcement
02:04 Conclusion and Thank You and make sure you subscribe to my channel!

Links to Live Stream on February 21, 2025
YouTube: https://www.youtube.com/live/aDSQK4NJxB8?si=A9rVfVzrB8ZRcYDL
LinkedIn: https://www.linkedin.com/events/excellikeapro-masteringcopilotf7291816311569932288/theater/

Blog post https://chrismenardtraining.com/post/copilot-excel-live-stream-february-21-2025

LinkedIn Post https://www.linkedin.com/posts/chris-menard_combining-tables-with-copilot-only-unique-activity-7292590685638045697-5DCb?utm_source=share&utm_medium=member_desktop

#copilot #copilotexcel #excel

-- EQUIPMENT USED ---------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

Видео Combining Tables with Copilot in Excel (only UNIQUE values) канала Chris Menard