Finding Unique Values in Excel: 3 Powerful Methods

In this video, I demonstrate three effective ways to find unique values from multiple columns in Microsoft Excel. Here's what I cover:

I walk you through using the UNIQUE function, creating a PivotTable with a special trick, and utilizing the Remove Duplicates feature. Using a sample dataset of training class sign-ups, I show how each method can help you identify unique combinations of class names and dates.

0:00 Introduction
0:15 Overview of the Sample Data
0:30 Method 1: UNIQUE Function
1:00 Method 2: PivotTable with Data Model
1:45 Method 3: Remove Duplicates Feature
2:15 Comparing Results
2:30 Wrap-up and Course Offerings

I also share a cool PivotTable trick using the "Add This Data to the Data Model" option, which allows for distinct count calculations - a feature you might not have seen before!

Don't forget to check out my comprehensive online training courses for Excel, Copilot, Teams, and OneNote to boost your productivity even further! The Excel file used in this video is available as a free download with my Excel course.

Thanks for watching and subscribing to my channel. Have a great day!

#ExcelTips #UniqueValues #DataAnalysisAnd make sure you subscribe to my channel!

- 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!