Unique values with multiple criteria
exceljet.net
Unique values with multiple criteria
To extract a list of unique values from a set of data, while applying one or more logical criteria, you can use the UNIQUE function together with the FILTER function. In the example shown, the formula in D5 is: =UNIQUE(FILTER(B5:B16,(C5:C16="b")*(D5:D16>5))) which returns the 3 unique colors in group B with a quantity > 5.
Aug 2, 2022
Microsoft Excel Excel Tips and Tricks
50 Ultimate Excel Tips and Tricks for 2020
50:17
50 Ultimate Excel Tips and Tricks for 2020
YouTubeSele Training
1.9M viewsMar 17, 2020
31 Excel Tricks that everyone should know!
45:38
31 Excel Tricks that everyone should know!
YouTubeLearn More
154.8K views10 months ago
Top 15 Excel Tips and Tricks of 2025 to Save Time and Speed Up Your Work
1:18:54
Top 15 Excel Tips and Tricks of 2025 to Save Time and Speed Up Your Work
YouTubeSimon Sez IT
9.3K views10 months ago
Top videos
This is how to get unique values in Excel. Skip remove duplicates when you need unique values and a total of each. Use the unique function in Excel along with sumifs. This excel hack will get the job done quickly. Excel trick to remove the duplicates. #excel #exceltricks #exceltips #exceltipsandtricks #xecutethevision #msexceltraining #msexcel #duplicates #unique #learnontiktok #training #bossupyourgame #business #excelhack #excelpro #learnexcel
0:26
This is how to get unique values in Excel. Skip remove duplicates when you need unique values and a total of each. Use the unique function in Excel along with sumifs. This excel hack will get the job done quickly. Excel trick to remove the duplicates. #excel #exceltricks #exceltips #exceltipsandtricks #xecutethevision #msexceltraining #msexcel #duplicates #unique #learnontiktok #training #bossupyourgame #business #excelhack #excelpro #learnexcel
TikTokexcel.at.xecutethevision
65.7K viewsDec 7, 2022
Extract unique items from a list
Extract unique items from a list
exceljet.net
Oct 26, 2022
UNIQUE Function
UNIQUE Function
exceljet.net
Aug 17, 2022
Microsoft Excel Excel Formulas
Every Microsoft 365 App: Explained!
6:51
Every Microsoft 365 App: Explained!
YouTubeTool Finder
1.1M viewsJun 15, 2020
Introducing Surface Laptop 5
1:22
Introducing Surface Laptop 5
YouTubeMicrosoft Surface
857.6K viewsOct 12, 2022
Hybrid work at Microsoft
2:27
Hybrid work at Microsoft
YouTubeMicrosoft
363.7K viewsOct 7, 2021
This is how to get unique values in Excel. Skip remove duplicates when you need unique values and a total of each. Use the unique function in Excel along with sumifs. This excel hack will get the job done quickly. Excel trick to remove the duplicates. #excel #exceltricks #exceltips #exceltipsandtricks #xecutethevision #msexceltraining #msexcel #duplicates #unique #learnontiktok #training #bossupyourgame #business #excelhack #excelpro #learnexcel
0:26
This is how to get unique values in Excel. Skip remove duplicates wh…
65.7K viewsDec 7, 2022
TikTokexcel.at.xecutethevision
Extract unique items from a list
Extract unique items from a list
Oct 26, 2022
exceljet.net
UNIQUE Function
UNIQUE Function
Aug 17, 2022
exceljet.net
Unique values from multiple ranges
Unique values from multiple ranges
Aug 13, 2024
exceljet.net
Unique values ignore blanks
Unique values ignore blanks
Aug 26, 2022
exceljet.net
Extract unique values from a list in excel with the UNIQUE function
3:43
Extract unique values from a list in excel with the UNIQUE function
649 viewsNov 15, 2021
YouTubeBitesize Excel
Filter for unique values or remove duplicate values
0:53
Filter for unique values or remove duplicate values
Oct 28, 2014
Microsoft
Count unique values with criteria
May 11, 2024
exceljet.net
1:14
How to Extract Unique Values From a Range in Excel
1.1K viewsNov 13, 2023
YouTubeBlue Link ERP
9:32
How to Extract Unique List Using Formula in Excel
20.9K viewsDec 11, 2021
YouTubeExcel Universe
5:10
How To Find Unique Values Using Advanced Filter In Excel
382K viewsNov 9, 2017
YouTubeExcel Campus - Jon
9:10
How to Extract Unique Values from Multiple Columns in Excel
108 views6 months ago
YouTubeExcel World
0:12
Excel Advanced Filter | Extract Unique Values Easily
52 views2 months ago
YouTubeNinja Excel Techniques
Sort and extract unique values
Oct 26, 2022
exceljet.net
12:40
UNIQUE Function in Excel | DYNAMIC Unique Lists (7 Examples)
6.1K viewsMar 23, 2023
YouTubeComputergaga
3 Ways to Remove Duplicates to Create a List of Unique Values in …
Oct 19, 2017
excelcampus.com
1:40
How to Extract a Unique List in Excel Using Formulas: Step-by-St…
239 viewsJul 17, 2024
YouTubeMANOJ KUMAR EXCEL
4:11
Extract Unique lists in Excel - Including IF conditions
5.6K viewsJul 31, 2024
YouTubeData Untelligence
5:39
How to Extract Unique List from the Data in Excel
6.5K viewsNov 14, 2020
YouTubeExcelskill Corner
0:55
How to Extract Unique Values from a Column in Excel
31.6K viewsJan 16, 2020
YouTubeFigureAssist
2:45
How to Extract Multiple Unique Columns in Excel 365
12.4K views11 months ago
YouTubeSimon Sez IT
13:16
How to Extract Unique Values Based on Criteria
8.5K viewsMay 19, 2023
YouTubeExcelDemy
0:21
How to Find Unique Values in Excel 🔥 | Easy Excel Tutorial for Beginners
2K views4 weeks ago
YouTubeIntrovert Excel
4:00
How to Extract Unique Values by Column in Excel 365
9K views11 months ago
YouTubeSimon Sez IT
5:23
How to Use the UNIQUE Function in Exel - Tutorial
9.7K viewsMar 3, 2022
YouTubeY. Acosta Excel Tutorials
8:20
How to extract unique values in Excel with VBA | VBA Scripting Di…
13.4K viewsAug 16, 2021
YouTubeAntriksh Sharma
0:28
Extract Unique List Using Excel UNIQUE Function
11K viewsJan 6, 2023
YouTubeEXCELSIRJI
9:41
Extract Unique List From Multiple Range | How to use Unique Functi…
1.8K viewsApr 30, 2022
YouTubeExcel Universe
3:16
How to Extract a Unique List based on Criteria in Excel
1.7K viewsOct 21, 2023
YouTubeExcelHow Tech
See more videos
Static thumbnail place holder