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
Awesome Microsoft #Excel & Google Sheets | Tips & Tricks | Excel Basement
4:09
Awesome Microsoft #Excel & Google Sheets | Tips & Tricks | Excel Basement
FacebookExcel Basement
1M viewsOct 18, 2022
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
These 47 Expert Excel Tricks Will Transform You Into a Power User
These 47 Expert Excel Tricks Will Transform You Into a Power User
pcmag.com
2 months ago
Top videos
Unique values from multiple ranges
Unique values from multiple ranges
exceljet.net
Aug 13, 2024
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
0:40
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
FacebookExcel Basics
1.1K viewsOct 30, 2023
3 Ways to Remove Duplicates to Create a List of Unique Values in Excel - Excel Campus
3 Ways to Remove Duplicates to Create a List of Unique Values in Excel - Excel Campus
excelcampus.com
Oct 19, 2017
Microsoft Excel Excel Formulas
Top Excel Formulas
Top Excel Formulas
intellipaat.com
89.9K viewsNov 23, 2023
How to Use Formulas & Functions in Excel
7:05
How to Use Formulas & Functions in Excel
Study.com
8K viewsJan 14, 2015
Learn Excel on Instagram: "📊 Top 26 Excel Formulas You Must Know! 🚀✨ Excel formulas are pre-defined calculations used to perform tasks like math, text manipulation, searching, and data analysis. . . . . #explore #explorepage✨ #excelcheatsheet #excellovers #excelfunctions #excelformulas #excelformulas #excel #msexcel #microsoftexcel #exceltipsandtricks #formula #exceltricks #excelshortcutkeys #spreadsheets #excel2025 #cheatsheet #monikaexcel01 MS Excel | Excel | Excel Tips | Excel Functions | E
0:10
Learn Excel on Instagram: "📊 Top 26 Excel Formulas You Must Know! 🚀✨ Excel formulas are pre-defined calculations used to perform tasks like math, text manipulation, searching, and data analysis. . . . . #explore #explorepage✨ #excelcheatsheet #excellovers #excelfunctions #excelformulas #excelformulas #excel #msexcel #microsoftexcel #exceltipsandtricks #formula #exceltricks #excelshortcutkeys #spreadsheets #excel2025 #cheatsheet #monikaexcel01 MS Excel | Excel | Excel Tips | Excel Functions | E
Instagrammonika_excel01
17.9K views5 months ago
Unique values from multiple ranges
Unique values from multiple ranges
Aug 13, 2024
exceljet.net
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
0:40
Excel UNIQUE function This function in Excel returns a list of u…
1.1K viewsOct 30, 2023
FacebookExcel Basics
3 Ways to Remove Duplicates to Create a List of Unique Values in Excel - Excel Campus
3 Ways to Remove Duplicates to Create a List of Unique Values in …
Oct 19, 2017
excelcampus.com
Count unique values with criteria
Count unique values with criteria
4 months ago
exceljet.net
Pivot table list unique values
Pivot table list unique values
Oct 27, 2022
exceljet.net
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
Unique values ignore blanks
Unique values ignore blanks
Aug 26, 2022
exceljet.net
0:53
Filter for unique values or remove duplicate values
Oct 28, 2014
Microsoft
Count unique values
Jan 6, 2025
exceljet.net
12:40
UNIQUE Function in Excel | DYNAMIC Unique Lists (7 Examples)
6.8K viewsMar 23, 2023
YouTubeComputergaga
Data validation unique values only
Oct 26, 2022
exceljet.net
0:33
How to Use the UNIQUE Function in Excel | Step-by-Step Guide #excel …
325 viewsDec 12, 2024
YouTubeMy Research
5:17
Finding Unique Values in Excel: 3 Powerful Methods
3K viewsAug 29, 2024
YouTubeChris Menard
3:54
Extract Unique Entries from a List in Excel Using the UNIQUE Function…
680 viewsJun 2, 2024
YouTubeSyed Shah Zahurullah Hussaini
0:38
Create a List of Unique Values in Excel - tutorial
5.4K views4 months ago
YouTubeExcel Tutorials by Y. Acosta
4:55
3 Easy Methods to Count Unique Values in Microsoft Excel
2.7K viewsNov 23, 2023
YouTubeMyExcelOnline.com
16:02
UNIQUE function in Excel (with 6 examples) | Remove duplicates wi…
88.2K viewsAug 12, 2020
YouTubeExcel Off The Grid
2:03
How to use the UNIQUE function in Excel to quickly find unique value…
422 viewsJan 28, 2024
YouTubeTech and AI Insights
7:13
How To Generate A Unique List From A Filtered List In Excel
2.4K viewsMar 19, 2024
YouTubeExcel Bytes
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…
8:31
Excel: Combine the awesome UNIQUE and SORT functions in Ex…
29.1K viewsApr 14, 2021
YouTubeChris Menard
2:34
Excel | Get UNIQUE List | Get UNIQUE Combination | UNIQUE fu…
7.7K viewsApr 24, 2022
YouTubeJosh Jagath
13:02
Microsoft Excel - Extract a Unique List of Values from a Column
117.5K viewsMay 6, 2022
YouTubeOfficeNewb.com
4:00
How to Extract Unique Values by Column in Excel 365
11.9K viewsNov 18, 2024
YouTubeSimon Sez IT
0:17
Generate Unique or Distinct List of Items in Excel
2.5K views8 months ago
YouTubeOffice Productivity Hub
Excel Quickie 7 - 3 Ways to View a List of Unique Records in Excel
4K viewsJul 25, 2019
YouTubeTeachExcel
5:37
Combine the UNIQUE and FILTER functions in Excel
22.3K viewsJun 12, 2024
YouTubeChris Menard
6:01
One Click, No Duplicates! Master the UNIQUE Function in Excel
195 viewsJul 11, 2024
YouTubeAnalytics Success
7:59
Combine multiple columns into one Unique List - Excel
49.8K viewsJan 6, 2022
YouTubeExcelMoments
See more videos
Static thumbnail place holder