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
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
Count unique values with criteria
Count unique values with criteria
exceljet.net
3 months ago
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
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
How to count duplicates and unique values in Excel - TechRepublic
How to count duplicates and unique values in Excel - TechRepublic
Jul 2, 2014
techrepublic.com
Unique values from multiple ranges
Unique values from multiple ranges
Aug 13, 2024
exceljet.net
3K views · 35 reactions | Excel UNIQUE function This function in Excel returns a list of unique values from a range or array. It works with any data type: text, numbers, dates, times, etc. #excel #exceltips #exceltutorial #reels | Excel Basics | Facebook
0:40
3K views · 35 reactions | Excel UNIQUE function This function in …
1.1K views1 month ago
FacebookExcel Basics
How to find and select unique rows in an Excel table
2:11
How to find and select unique rows in an Excel table
1.2K viewsOct 3, 2018
ablebits.com
5:10
How To Find Unique Values Using Advanced Filter In Excel
386.6K viewsNov 9, 2017
YouTubeExcel Campus - Jon
Unique values ignore blanks
Aug 26, 2022
exceljet.net
0:12
Excel tip advanced filter unique values
1.6M viewsDec 15, 2022
YouTubeWork Management Solutions at XecuteTheVision
5:23
How to Use the UNIQUE Function in Exel - Tutorial
9.7K viewsMar 3, 2022
YouTubeY. Acosta Excel Tutorials
3:43
Extract unique values from a list in excel with the UNIQUE function
697 viewsNov 15, 2021
YouTubeBitesize Excel
12:40
UNIQUE Function in Excel | DYNAMIC Unique Lists (7 Examples)
6.7K viewsMar 23, 2023
YouTubeComputergaga
5:17
Finding Unique Values in Excel: 3 Powerful Methods
2.9K viewsAug 29, 2024
YouTubeChris Menard
0:36
How to Extract Unique Information in MS Excel using Unique Functio…
55.1K viewsMar 11, 2022
YouTubeSkills2Rise
7:30
Excel Tutorial - Identify unique values in a data set
1.9K viewsDec 6, 2021
YouTubeLinkedIn Learning
Count unique values in a range with COUNTIF
Aug 21, 2022
exceljet.net
Excel Tricks : Generate Unique Values in a Column In Excel || Exc…
3.8K viewsApr 28, 2018
YouTubedptutorials
3:55
How To Get Unique Values From Two Columns In Excel || Excel Tip…
107K viewsNov 8, 2019
YouTubedptutorials
2:03
How to use the UNIQUE function in Excel to quickly find unique value…
418 viewsJan 28, 2024
YouTubeTech and AI Insights
1:20
How to Count Unique Values in Excel | How to Use the COUNTA a…
79.9K viewsSep 14, 2022
YouTubeExcel, Word and PowerPoint Tutorials from Ho…
4:00
How to Extract Unique Values by Column in Excel 365
11.5K viewsNov 18, 2024
YouTubeSimon Sez IT
8:31
Excel: Combine the awesome UNIQUE and SORT functions in Ex…
29.9K viewsApr 14, 2021
YouTubeChris Menard
0:55
How to Extract Unique Values from a Column in Excel
31.6K viewsJan 16, 2020
YouTubeFigureAssist
2:34
Excel | Get UNIQUE List | Get UNIQUE Combination | UNIQUE fu…
7.7K viewsApr 24, 2022
YouTubeJosh Jagath
16:08
Excel VBA Get Unique Values on Multiple Columns
4.1K viewsAug 7, 2022
YouTubeThe Excel Cave
0:26
How to count unique values Excel
239.9K viewsJul 24, 2018
YouTubeSpreadsheetWeb
2:45
How to Extract Multiple Unique Columns in Excel 365
14.5K viewsNov 14, 2024
YouTubeSimon Sez IT
0:28
Extract Unique List Using Excel UNIQUE Function
11K viewsJan 6, 2023
YouTubeEXCELSIRJI
See more videos
Static thumbnail place holder