Excel VBA: Practical Guide to Finding Unique Values (Advanced Filter & Dictionaries)
HTML-код
- Опубликовано: 22 июл 2024
- 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:
skillsandautomation.com/usefu...
Macro file can be downloaded from Github:
github.com/skillsandautomatio...
Microsoft Links shown in the video:
Advanced Filter:
learn.microsoft.com/en-us/off...
Dictionary
learn.microsoft.com/en-us/off...
Split Function
learn.microsoft.com/en-us/off...
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) Наука
Hello, Links for the code and macro file are given within the description. See you in the next video!
Thanks much!