Unique values with criteria
exceljet.net
Unique values with 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=E4)) which returns the 5 unique values in group A, as seen in E5:E9.
Aug 26, 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 multiple criteria
Unique values with multiple criteria
exceljet.net
Aug 2, 2022
UNIQUE function in Excel (How to 6 Examples)
UNIQUE function in Excel (How to 6 Examples)
exceloffthegrid.com
Jan 24, 2023
Return Multiple Values for a Lookup Formula in Excel with FILTER and UNIQUE - Excel Campus
Return Multiple Values for a Lookup Formula in Excel with FILTER and UNIQUE - Excel Campus
excelcampus.com
Jan 22, 2020
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 multiple criteria
Unique values with multiple criteria
Aug 2, 2022
exceljet.net
UNIQUE function in Excel (How to 6 Examples)
UNIQUE function in Excel (How to 6 Examples)
Jan 24, 2023
exceloffthegrid.com
Return Multiple Values for a Lookup Formula in Excel with FILTER and UNIQUE - Excel Campus
Return Multiple Values for a Lookup Formula in Excel with FILTER and …
Jan 22, 2020
excelcampus.com
Excel SUMIF & UNIQUE Function Tutorial
1:14
Excel SUMIF & UNIQUE Function Tutorial
271K viewsMay 21, 2023
TikTokexcelwithnhel
UNIQUE Function
UNIQUE Function
Aug 17, 2022
exceljet.net
Count unique values with criteria
Count unique values with criteria
3 months ago
exceljet.net
Excel by Karstrom på TikTok
0:34
Excel by Karstrom på TikTok
22K viewsMar 2, 2023
TikTokexcelbykarstrom
FILTER Function
8 months ago
exceljet.net
0:53
Filter for unique values or remove duplicate values - Microsoft Support
Oct 28, 2014
Microsoft
Unique values ignore blanks
Aug 26, 2022
exceljet.net
0:55
How to Extract Unique Values from a Column in Excel
31.6K viewsJan 16, 2020
YouTubeFigureAssist
0:50
How to filter for unique values in Excel
27 viewsMar 26, 2024
YouTubeThe-IT-Fox
12:17
Unique and Filter Functions in Microsoft Excel -Introduction
1.1K viewsMay 7, 2020
YouTubeExcelMoments
2:45
How to Extract Multiple Unique Columns in Excel 365
14.5K viewsNov 14, 2024
YouTubeSimon Sez IT
13:16
How to Extract Unique Values Based on Criteria
8.6K viewsMay 19, 2023
YouTubeExcelDemy
13:02
Microsoft Excel - Extract a Unique List of Values from a Column
122.3K viewsMay 6, 2022
YouTubeOfficeNewb.com
12:40
UNIQUE Function in Excel | DYNAMIC Unique Lists (7 Examples)
6.7K viewsMar 23, 2023
YouTubeComputergaga
0:12
Excel tip advanced filter unique values
1.6M viewsDec 15, 2022
YouTubeWork Management Solutions at XecuteTheVision
4:11
Extract Unique lists in Excel - Including IF conditions
6.7K viewsJul 31, 2024
YouTubeData Untelligence
2:22
Advanced Filtering || Filter unique values in a column using Microsof…
111 viewsOct 18, 2024
YouTubeSammyst The Analyst
5:39
How to Extract Unique List from the Data in Excel
6.6K viewsNov 14, 2020
YouTubeExcelskill Corner
Extract unique items from a list
May 16, 2024
exceljet.net
4:08
Get UNIQUE VALUES with MULTIPLE CRITERIA in MS Excel (…
12.2K viewsJul 15, 2023
YouTubeWisdom by Data
4:55
3 Easy Methods to Count Unique Values in Microsoft Excel
2.6K viewsNov 23, 2023
YouTubeMyExcelOnline.com
3:55
How To Get Unique Values From Two Columns In Excel || Excel Tip…
107K viewsNov 8, 2019
YouTubedptutorials
7:30
Excel Tutorial - Identify unique values in a data set
1.9K viewsDec 6, 2021
YouTubeLinkedIn Learning
1:42
[Power Query] Extract Unique Values From Multiple Columns in …
12.1K viewsJan 17, 2020
YouTubeShort Excel
8:31
Excel: Combine the awesome UNIQUE and SORT functions in Ex…
29.9K viewsApr 14, 2021
YouTubeChris Menard
5:37
Combine the UNIQUE and FILTER functions in Excel
21.7K viewsJun 12, 2024
YouTubeChris Menard
See more videos
Static thumbnail place holder