Excel VBA: Practical Guide to Finding Unique Values (Advanced Filter & Dictionaries)

Learn how to extract just the unique values from any list. Our focus will be on two techniques, namely Advanced Filter and Dictionary. For our solution, we will deep-dive into interesting concepts such as Classes and Split function. At the end, we will talk about which technique to use when.

We will cover three scenarios:
1. Find Unique Values based on a single column
2. Find Unique Values based on two/ multiple columns
3. Find Unique Values based on a certain criteria

#vba #learnvba #excelvba #excel #exceltutorial #exceltips

We will tackle each scenario using both Advanced Filter and Dictionary.

Code available at:

Macro file can be downloaded from Github:

Microsoft Links shown in the video:
Advanced Filter:

Dictionary

Split Function

00:00 Intro
00:16 Scenario
01:21 Advanced Filter (Single Column)
03:57 Advanced Filter (Multiple Column)
05:04 Advanced Filter (Based on Criteria)
06:39 Dictionary (Single Column)
10:12 Dictionary with Split Function (Multiple Column)
13:58 Dictionary with Classes (Multiple Column)
17:55 Dictionary (Based on Criteria)

[SkillsandAutomation]

Hello, Links for the code and macro file are given within the description. See you in the next video!