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
Excel Tutorial
Pivot Table Excel Tutorial
13:36
Pivot Table Excel Tutorial
YouTubeKevin Stratvert
5M viewsMay 21, 2019
"🎯 Mastering Excel is a breeze with this step-by-step tutorial! Discover the top 10 basic functions and become an Excel wizard in no time! 💡 #exceltutorial #Excel #reelsfb #spreadsheet #exceltips | Excel Basics
5:53
"🎯 Mastering Excel is a breeze with this step-by-step tutorial! Discover the top 10 basic functions and become an Excel wizard in no time! 💡 #exceltutorial #Excel #reelsfb #spreadsheet #exceltips | Excel Basics
FacebookExcel Basics
326.6K viewsAug 28, 2023
🎯 Mastering Excel is a breeze with this step-by-step tutorial! Discover the top 10 basic functions and become an Excel wizard in no time! 💡 #exceltutorial #exceltips #Excel #reelsfb #spreadsheet | Excel Basics
0:58
🎯 Mastering Excel is a breeze with this step-by-step tutorial! Discover the top 10 basic functions and become an Excel wizard in no time! 💡 #exceltutorial #exceltips #Excel #reelsfb #spreadsheet | Excel Basics
FacebookExcel Basics
128.9K viewsAug 28, 2023
Top videos
How do you find unique values in Excel across multiple columns? - TimesMojo
How do you find unique values in Excel across multiple columns? - TimesMojo
timesmojo.com
Jul 7, 2022
Excel Uniqueness Unleashed: Count Unique Values with Criteria! 📊🔍🔢 Unlock the power of uniqueness in Excel! Learn how to count unique values based on specific criteria, adding precision to your data analysis. Elevate your spreadsheet skills and dive into this tutorial for a dynamic approach to counting unique occurrences. Watch, learn, and conquer your data uniqueness challenges! 💻🚀 #ExcelTips #CountUniqueValues #SpreadsheetSkills #DataAnalysis #ExcelMagic | Excel Formulas Unleashed
0:25
Excel Uniqueness Unleashed: Count Unique Values with Criteria! 📊🔍🔢 Unlock the power of uniqueness in Excel! Learn how to count unique values based on specific criteria, adding precision to your data analysis. Elevate your spreadsheet skills and dive into this tutorial for a dynamic approach to counting unique occurrences. Watch, learn, and conquer your data uniqueness challenges! 💻🚀 #ExcelTips #CountUniqueValues #SpreadsheetSkills #DataAnalysis #ExcelMagic | Excel Formulas Unleashed
FacebookExcel Formulas Unleashed
4.2K viewsFeb 1, 2024
How to Count Uniques in Excel‼️ ❤️ and follow for daily tips! 🗂️ Save this post for future reference! 👯 Share it with a friend! 🎁 Get Excel Templates, PDF Cheat Sheets, Trackers, and Trainings at the link in our bio! 🎯 Follow us on Instagram, YouTube, TikTok, and more at the link in our bio! #cheatsheets #excel #exceltips #googlesheets #spreadsheets #accounting #finance #corporate #office #work #tutorial | CheatSheets
0:32
How to Count Uniques in Excel‼️ ❤️ and follow for daily tips! 🗂️ Save this post for future reference! 👯 Share it with a friend! 🎁 Get Excel Templates, PDF Cheat Sheets, Trackers, and Trainings at the link in our bio! 🎯 Follow us on Instagram, YouTube, TikTok, and more at the link in our bio! #cheatsheets #excel #exceltips #googlesheets #spreadsheets #accounting #finance #corporate #office #work #tutorial | CheatSheets
FacebookCheatSheets
11.3K views5 months ago
Excel Tips and Tricks
50 Excel Tips, Tricks and Shortcuts to Boost Efficiency
45:34
50 Excel Tips, Tricks and Shortcuts to Boost Efficiency
YouTubeBeyond Excel
3K viewsJan 11, 2023
Essential Excel Tips and Tricks for Efficiency
0:11
Essential Excel Tips and Tricks for Efficiency
TikTokms.excelmastery
101.7K viewsFeb 8, 2025
Top Excel Tricks to Enhance Your Productivity
0:19
Top Excel Tricks to Enhance Your Productivity
TikTokms.excelmastery
298.5K views8 months ago
How do you find unique values in Excel across multiple columns? - TimesMojo
How do you find unique values in Excel across multiple columns? - …
Jul 7, 2022
timesmojo.com
Excel Uniqueness Unleashed: Count Unique Values with Criteria! 📊🔍🔢 Unlock the power of uniqueness in Excel! Learn how to count unique values based on specific criteria, adding precision to your data analysis. Elevate your spreadsheet skills and dive into this tutorial for a dynamic approach to counting unique occurrences. Watch, learn, and conquer your data uniqueness challenges! 💻🚀 #ExcelTips #CountUniqueValues #SpreadsheetSkills #DataAnalysis #ExcelMagic | Excel Formulas Unleashed
0:25
Excel Uniqueness Unleashed: Count Unique Values with Criteria! 📊🔍🔢 Unlo…
4.2K viewsFeb 1, 2024
FacebookExcel Formulas Unleashed
How to Count Uniques in Excel‼️ ❤️ and follow for daily tips! 🗂️ Save this post for future reference! 👯 Share it with a friend! 🎁 Get Excel Templates, PDF Cheat Sheets, Trackers, and Trainings at the link in our bio! 🎯 Follow us on Instagram, YouTube, TikTok, and more at the link in our bio! #cheatsheets #excel #exceltips #googlesheets #spreadsheets #accounting #finance #corporate #office #work #tutorial | CheatSheets
0:32
How to Count Uniques in Excel‼️ ❤️ and follow for daily tips! 🗂️ S…
11.3K views5 months ago
FacebookCheatSheets
Excel Unique & CountIf Function Tutorial
1:08
Excel Unique & CountIf Function Tutorial
121.5K viewsMay 20, 2023
TikTokexcelwithnhel
Excel by Karstrom på TikTok
0:34
Excel by Karstrom på TikTok
22K viewsMar 2, 2023
TikTokexcelbykarstrom
Combine columns in Excel without losing data - 3 quick ways
6:30
Combine columns in Excel without losing data - 3 quick ways
Mar 23, 2023
ablebits.com
#ViralReels #TrendingNow #ReelsDaily #MustSee #QuickTips Excel Hack: Instantly Extract Unique Values & Count Duplicates! Elevate your Excel skills with this powerful hack! In this video, you'll discover how to quickly extract unique values and count duplicates using built-in Excel functions. This technique is perfect for data analysts, students, and professionals who want to streamline their workflow and enhance productivity. You’ll learn how to use Excel's UNIQUE function to extract distinct va
0:28
#ViralReels #TrendingNow #ReelsDaily #MustSee #QuickTip…
10.7K views9 months ago
FacebookOvins Kawre
0:53
Filter for unique values or remove duplicate values
Oct 28, 2014
Microsoft
0:48
Osmosis
648.4K viewsDec 8, 2007
YouTubeCarpe Noctum
2:00
How to Create Code 39 Barcodes in Excel
97.8K viewsJul 22, 2011
YouTubeIDAutomation Barcode Technology
13:29
Excel Sorting and Filtering Data
1M viewsJun 7, 2018
YouTubeThe Organic Chemistry Tutor
8:22
How to Combine 2 Excel Workbooks Using VLOOKUP
1.5M viewsAug 13, 2012
YouTubeDanny Rocks
7:53
Excel SUM and SUMIF Formula in Excel
405.2K viewsDec 11, 2019
YouTubeKevin Stratvert
14:36
How to use COUNTIF and COUNTIFS in Microsoft Excel
1M viewsJan 27, 2020
YouTubeKevin Stratvert
7:01
Excel Dynamic Arrays (How they will change EVERYTHING!)
779.3K viewsOct 18, 2018
YouTubeLeila Gharani
1:12
How to Subtract Cells in Microsoft Excel 2017
1.1M viewsJan 12, 2017
YouTubeThe How-To Scholar: Education
6:26
How to merge duplicate rows in Excel
373.8K viewsSep 15, 2016
YouTubeAblebits
2:17
How To: Filter Duplicate Values in Excel
124.6K viewsFeb 2, 2013
YouTubeNeil Malek
7:24
Advanced Filter Excel (And, Or, Between Conditions for Criteria R…
823.6K viewsMar 8, 2018
YouTubeLeila Gharani
16:44
7 Ways to Use Vlookup in Excel
3M viewsDec 7, 2018
YouTubeMy E-Lesson
11:13
How to do SUMIF with Multiple Columns Tutorial - SUMIFS in Excel
177.7K viewsMar 29, 2021
YouTubeSimon Sez IT
4:02
How To Paste to Visible Cells in Excel
778.6K viewsJan 15, 2015
YouTubeExcel Campus - Jon
1:00
How Do I Calculate 10% Of A Number In Excel
11.9K viewsFeb 11, 2019
YouTube28 November 2016
18:37
🔎 How to Create Searchable Drop Down List in Excel
410.8K viewsJul 19, 2021
YouTubeKevin Stratvert
15:34
UNIQUE() Function for Excel 365 - Remove Duplicates Using Formulas
14.6K viewsAug 25, 2020
YouTubeTeachExcel
4:52
Goal Seek for a Range with Multiple Goals (Excel VBA)
21.1K viewsJun 25, 2019
YouTubetheSoftwareGuy
5:03
Find Unique Values in Microsoft Excel: 4 Methods for Beginners
37.3K viewsJun 4, 2021
YouTubeChris Menard
1:19
How to Subtract in Excel - Quick and Easy Tutorial
59.6K viewsJun 24, 2021
YouTubeSimply Excel
6:31
How to Combine (Concatenate) Data from Multiple Rows into One Cell i…
574.8K viewsDec 10, 2015
YouTubeExcel Tactics
See more videos
Static thumbnail place holder