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 Unique Values
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
The UNIQUE 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 #exceltricks #exceltutorial
0:39
The UNIQUE 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 #exceltricks #exceltutorial
TikTokexcel.basics
1.9K viewsSep 26, 2023
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 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
TikTokexcel.at.xecutethevision
65.7K viewsDec 7, 2022
Top videos
Unique values from multiple ranges
Unique values from multiple ranges
exceljet.net
Aug 13, 2024
How to find unique/duplicate values between two columns in excel?
How to find unique/duplicate values between two columns in excel?
extendoffice.com
May 17, 2012
Count unique values with criteria
Count unique values with criteria
exceljet.net
4 months ago
Excel Data Analysis
Excel for Data Analysis: Ultimate Guide
Excel for Data Analysis: Ultimate Guide
git.ir
83 viewsOct 22, 2024
Fundamentals of Data Analysis in Excel
Fundamentals of Data Analysis in Excel
git.ir
3.8K viewsFeb 22, 2025
Pivot Table Excel Tutorial
13:36
Pivot Table Excel Tutorial
YouTubeKevin Stratvert
5M viewsMay 21, 2019
Unique values from multiple ranges
Unique values from multiple ranges
Aug 13, 2024
exceljet.net
How to find unique/duplicate values between two columns in excel?
How to find unique/duplicate values between two columns in excel?
May 17, 2012
extendoffice.com
Count unique values with criteria
Count unique values with criteria
4 months ago
exceljet.net
UNIQUE Function
UNIQUE Function
Aug 17, 2022
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
Extract unique items from a list
Extract unique items from a list
May 16, 2024
exceljet.net
Filter for unique values or remove duplicate values
0:53
Filter for unique values or remove duplicate values
Oct 28, 2014
Microsoft
2 Tricks to Create Unique Combinations From Multiple Columns – Power Query #7
2 Tricks to Create Unique Combinations From Multiple Colu…
38.4K viewsJun 1, 2018
YouTubeBI Gorilla
Duplicates over multiple columns in Excel
2:14
Duplicates over multiple columns in Excel
14.5K viewsAug 10, 2021
YouTubeAuditExcel Advanced Excel and Financial Mod…
How to count unique values Excel
0:26
How to count unique values Excel
242.4K viewsJul 24, 2018
YouTubeSpreadsheetWeb
How to Get a UNIQUE List from Many Columns Using FLATTEN in Google Sheets
5:24
How to Get a UNIQUE List from Many Columns Using FLATTEN i…
197.6K viewsJul 20, 2021
YouTubeLeila Gharani
Excel: Combine the awesome UNIQUE and SORT functions in Excel
8:31
Excel: Combine the awesome UNIQUE and SORT functions in E…
30.2K viewsApr 14, 2021
YouTubeChris Menard
A Formula For Non-adjacent Columns In Excel
4:39
A Formula For Non-adjacent Columns In Excel
35.2K viewsFeb 18, 2021
YouTubeExcel Campus - Jon
How to Extract Unique Values in Excel
7:56
How to Extract Unique Values in Excel
47.8K viewsJun 10, 2021
YouTubeSimon Sez IT
How to Extract Unique Values from a Column in Excel
0:55
How to Extract Unique Values from a Column in Excel
31.6K viewsJan 16, 2020
YouTubeFigureAssist
Find Unique Values in Microsoft Excel: 4 Methods for Beginners
5:03
Find Unique Values in Microsoft Excel: 4 Methods for Beginners
37.3K viewsJun 4, 2021
YouTubeChris Menard
Highlight Duplicate Values in Two Columns - Excel Formula
8:09
Highlight Duplicate Values in Two Columns - Excel Formula
78.6K viewsMar 3, 2017
YouTubeComputergaga
Dealing with Duplicates in Excel and Finding Unique Data
7:43
Dealing with Duplicates in Excel and Finding Unique Data
161K viewsNov 5, 2018
YouTubeTechnology for Teachers and Students
How To Get Unique Values From Two Columns In Excel || Excel Tips & Tricks || dptutorials
3:55
How To Get Unique Values From Two Columns In Excel || Excel Tip…
106.9K viewsNov 8, 2019
YouTubedptutorials
Combine two sheets of only unique data in Excel
3:44
Combine two sheets of only unique data in Excel
8.6K viewsMay 15, 2018
YouTubeBarb Henderson
Lookup and return multiple comma-separated values in Excel
5:37
Lookup and return multiple comma-separated values in Excel
15.1K viewsApr 17, 2021
YouTubePrasad Hariharan
How to Count Number of Unique Values with criteria in Excel | Microsoft Excel Tutorial
3:16
How to Count Number of Unique Values with criteria in Excel | Micr…
14.9K viewsOct 15, 2017
YouTubeMITutorials
UNIQUE function in Excel (with 6 examples) | Remove duplicates with a function | Excel Off The Grid
16:02
UNIQUE function in Excel (with 6 examples) | Remove duplicates wi…
88.2K viewsAug 12, 2020
YouTubeExcel Off The Grid
Quickly find Duplicates and Unique values in Two Columns of Excel
1:09
Quickly find Duplicates and Unique values in Two Columns of Excel
12.2K viewsNov 24, 2019
YouTubeThe Akshay
How to Count Unique Values with Multiple Condition in Excel | Countifs with Multiple Criteria
8:20
How to Count Unique Values with Multiple Condition in Excel | Coun…
41.4K viewsAug 2, 2020
YouTubeTeach To Each
How to Count Unique Values with Multiple Condition in Excel
15:34
How to Count Unique Values with Multiple Condition in Excel
66.7K viewsMay 8, 2021
YouTubeExcel Universe
Lookup and Return Multiple Results into One Cell Separated by Comma or Similar Delimiter
6:28
Lookup and Return Multiple Results into One Cell Separated by Comm…
70K viewsFeb 19, 2021
YouTubeChester Tugwell
Excel UNIQUE Function | Excel One Minute Functions Explained
2:23
Excel UNIQUE Function | Excel One Minute Functions Explained
167.7K viewsOct 8, 2021
YouTubeChris Menard
Remove Duplicates from Column in Excel UNIQUE Function
0:58
Remove Duplicates from Column in Excel UNIQUE Function
10.8K viewsFeb 21, 2024
YouTubeExcel ASPC
See more