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
34K views · 517 reactions | Convert Excel into PDF | Microsoft Excel | Tips and tricks of Excel | Subscribe Youtube Channel for more videos https://youtube.com/@excelexpert7 #Excel #exceltips #exceltricks #excelexpert #excelprofessional #learnexcel #foryou #foryourpage #exceltraining #exceltutorial | Excel Expert | Facebook
0:34
34K views · 517 reactions | Convert Excel into PDF | Microsoft Excel | Tips and tricks of Excel | Subscribe Youtube Channel for more videos https://youtube.com/@excelexpert7 #Excel #exceltips #exceltricks #excelexpert #excelprofessional #learnexcel #foryou #foryourpage #exceltraining #exceltutorial | Excel Expert | Facebook
FacebookExcel Expert
16.5K views1 week ago
330K views · 14K reactions | 10 Awesome Microsoft #Excel Tips & Tricks | Excel Basement | Facebook
4:09
330K views · 14K reactions | 10 Awesome Microsoft #Excel Tips & Tricks | Excel Basement | Facebook
FacebookExcel Basement
330.5K views4 weeks ago
21 Excel Tips and Tricks to Make You a PRO in 2024 (Free PDF)
21 Excel Tips and Tricks to Make You a PRO in 2024 (Free PDF)
excelchamps.com
Jul 24, 2024
Top videos
Unique values with criteria
Unique values with criteria
exceljet.net
Aug 26, 2022
How to Count Unique Values in Excel with the UNIQUE Function
How to Count Unique Values in Excel with the UNIQUE Function
goskills.com
Feb 21, 2021
UNIQUE Function
UNIQUE Function
exceljet.net
Aug 17, 2022
Microsoft Excel Excel Formulas
101 Advanced Excel Formulas & Functions Examples
101 Advanced Excel Formulas & Functions Examples
myexcelonline.com
127K viewsMar 3, 2021
Bring AI to your formulas with the COPILOT function in Excel
Bring AI to your formulas with the COPILOT function in Excel
Microsoft BlogsCatherine_Pidgeon
6 months ago
Subtraction in Microsoft Excel
0:42
Subtraction in Microsoft Excel
YouTubeMicrosoft 365
510K viewsOct 3, 2019
Unique values with criteria
Unique values with criteria
Aug 26, 2022
exceljet.net
How to Count Unique Values in Excel with the UNIQUE Function
How to Count Unique Values in Excel with the UNIQUE Function
Feb 21, 2021
goskills.com
UNIQUE Function
UNIQUE Function
Aug 17, 2022
exceljet.net
Count unique values with criteria
Count unique values with criteria
3 months ago
exceljet.net
FILTER Function
FILTER Function
8 months ago
exceljet.net
Unique and Filter Functions in Microsoft Excel -Introduction
12:17
Unique and Filter Functions in Microsoft Excel -Introduction
1.1K viewsMay 7, 2020
YouTubeExcelMoments
How To Find Unique Values Using Advanced Filter In Excel
5:10
How To Find Unique Values Using Advanced Filter In Excel
386.6K viewsNov 9, 2017
YouTubeExcel Campus - Jon
5:23
How to Use the UNIQUE Function in Exel - Tutorial
9.7K viewsMar 3, 2022
YouTubeY. Acosta Excel Tutorials
0:50
How to filter for unique values in Excel
27 viewsMar 26, 2024
YouTubeThe-IT-Fox
7:13
How To Generate A Unique List From A Filtered List In Excel
2.2K viewsMar 19, 2024
YouTubeExcel Bytes
2:22
Advanced Filtering || Filter unique values in a column using Microsof…
111 viewsOct 18, 2024
YouTubeSammyst The Analyst
3:57
Advanced drop down lists with dynamic array formulas UNIQUE …
2K viewsJul 12, 2021
YouTubeBitesize Excel
4:08
Get UNIQUE VALUES with MULTIPLE CRITERIA in MS Excel (…
12.2K viewsJul 15, 2023
YouTubeWisdom by Data
12:40
UNIQUE Function in Excel | DYNAMIC Unique Lists (7 Examples)
6.7K viewsMar 23, 2023
YouTubeComputergaga
13:16
How to Extract Unique Values Based on Criteria
8.6K viewsMay 19, 2023
YouTubeExcelDemy
5:37
Combine the UNIQUE and FILTER functions in Excel
21.7K viewsJun 12, 2024
YouTubeChris Menard
Unique values from multiple ranges
Aug 13, 2024
exceljet.net
3:30
How to use Filter function in Excel and Filter data based on 1 or 2 or …
75.3K viewsApr 2, 2020
YouTubeExcel Rush
Unique values ignore blanks
Aug 26, 2022
exceljet.net
0:53
Filter for unique values or remove duplicate values - Microsoft Support
Oct 28, 2014
Microsoft
6:46
FILTERXML - combine multiple columns into one Unique List - Ex…
8.4K viewsJan 8, 2022
YouTubeExcelMoments
7:30
Excel Tutorial - Identify unique values in a data set
1.9K viewsDec 6, 2021
YouTubeLinkedIn Learning
4:55
3 Easy Methods to Count Unique Values in Microsoft Excel
2.6K viewsNov 23, 2023
YouTubeMyExcelOnline.com
0:12
Excel tip advanced filter unique values
1.6M viewsDec 15, 2022
YouTubeWork Management Solutions at XecuteTheVision
2:58
MS Excel - Unique Function (How to use) | Excel Formula
10.2K viewsJul 29, 2020
YouTubeYoda Learning Academy
8:23
How to Use AutoFilter in Excel: A Complete Guide to Creating Smar…
47.3K viewsJun 9, 2012
YouTubeDoug H
5:05
How to use the FILTER Function in Excel (multiple use cases)
10K viewsMar 27, 2024
YouTubeExcel Dictionary
8:43
Using the Excel FILTER Function to Create Dynamic Filters
513.5K viewsApr 5, 2021
YouTubeTechnology for Teachers and Students
8:31
Excel: Combine the awesome UNIQUE and SORT functions in Ex…
29.9K viewsApr 14, 2021
YouTubeChris Menard
See more videos
Static thumbnail place holder