All
Search
Images
Videos
Shorts
Maps
News
More
Shopping
Flights
Travel
Notebook
Report an inappropriate content
Please select one of the options below.
Not Relevant
Offensive
Adult
Child Sexual Abuse
Length
All
Short (less than 5 minutes)
Medium (5-20 minutes)
Long (more than 20 minutes)
Date
All
Past 24 hours
Past week
Past month
Past year
Resolution
All
Lower than 360p
360p or higher
480p or higher
720p or higher
1080p or higher
Source
All
Dailymotion
Vimeo
Metacafe
Hulu
VEVO
Myspace
MTV
CBS
Fox
CNN
MSN
Price
All
Free
Paid
Clear filters
SafeSearch:
Moderate
Strict
Moderate (default)
Off
Filter
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 Conditional Formatting
6:43
Conditional Formatting in Excel Tutorial
YouTube
Kevin Stratvert
885.5K views
Jul 30, 2019
25:18
Excel Conditional Formatting (Overview + Advanced Examples)
YouTube
TrumpExcel
97.4K views
May 21, 2019
3:46
Excel: Conditional Formatting
YouTube
LearnFree
961.4K views
Feb 8, 2016
Top videos
Count unique values with criteria
exceljet.net
1 month ago
2:14
How to Create Color-Coded Drop-Down Lists in Excel
TikTok
excel_with_kyle
273.5K views
Oct 14, 2022
How to Highlight Duplicate or Unique Values in Excel
YouTube
Modern School Bus
2.5K views
Apr 10, 2023
Excel Color Schemes
3:42
How to Use Color Scales in Excel (Conditional Formatting)
YouTube
Excel Tutorials by EasyClick
425.7K views
Oct 29, 2019
16:00
Stop Wasting Your Time Playing with Excel Colours - Do This Instead
YouTube
Up4Excel
14.1K views
Dec 7, 2022
7:20
Create Your Own Custom Color Palettes in Microsoft Excel | Jon Schwabish
YouTube
Jon Schwabish
7.2K views
Jun 11, 2024
Count unique values with criteria
1 month ago
exceljet.net
2:14
How to Create Color-Coded Drop-Down Lists in Excel
273.5K views
Oct 14, 2022
TikTok
excel_with_kyle
How to Highlight Duplicate or Unique Values in Excel
2.5K views
Apr 10, 2023
YouTube
Modern School Bus
Excel - Do a Count of Unique Values | Text and/or Number | Get a Coun
…
154K views
May 6, 2021
YouTube
Chester Tugwell
Recoding Variables in Excel
48.2K views
May 7, 2015
YouTube
Dr. Todd Grande
1:52
How do I color a cell in Excel based on a date range?
17.3K views
Jan 25, 2021
YouTube
That Dubai Analyst
3:47
How To Use COLOR In Your Data Visualization - BEGINNERS GUIDE
13.5K views
Jun 2, 2021
YouTube
UNDATABLE
3:44
How to Automatically Color Code in Excel
50.2K views
Oct 6, 2020
YouTube
Guiding Tech
0:26
How to count unique values Excel
235.3K views
Jul 24, 2018
YouTube
SpreadsheetWeb
2:04
Color Coding Data in Excel: Inputs vs. Formulas
14.7K views
Oct 21, 2017
YouTube
Eric Andrews
16:12
Four SMART Ways to use Custom Formatting instead of Conditional
…
1.2M views
Aug 2, 2017
YouTube
Leila Gharani
3:42
How to Use Color Scales in Excel (Conditional Formatting)
425.7K views
Oct 29, 2019
YouTube
Excel Tutorials by EasyClick Academy
1:46
How to Count Unique Text Values in a Range in Excel
20.1K views
Jun 4, 2019
YouTube
Excelchat
8:31
Excel: Combine the awesome UNIQUE and SORT functions in Ex
…
29.5K views
Apr 14, 2021
YouTube
Chris Menard
17:30
Categorical scatter plot in Excel
20.8K views
Jul 30, 2021
YouTube
Peter Klappa
4:39
A Formula For Non-adjacent Columns In Excel
34.9K views
Feb 18, 2021
YouTube
Excel Campus - Jon
7:36
How to Change the color in Excel by formula - Many Examples
107.2K views
Apr 20, 2021
YouTube
Excel Exercice
5:03
Find Unique Values in Microsoft Excel: 4 Methods for Beginners
36.9K views
Jun 4, 2021
YouTube
Chris Menard
5:35
Scheduling Tip: Color-Coding Your Calendar
33.4K views
Jun 1, 2018
YouTube
C3Worx
11:35
Excel Formulas Based on Cell Color - Files Included
80.8K views
May 16, 2018
YouTube
TeachExcel
4:49
Converting Numerical Data to Categorical (multiple categories)
…
49.5K views
May 13, 2016
YouTube
THE IT CHANNEL
11:20
Excel: Converting a Scale Variable to a Categorical Variable - Part 1
8.6K views
Jul 9, 2019
YouTube
Maths and Stats
7:13
Adding a Category column to Excel data - using Excel techniques
183.4K views
May 8, 2014
YouTube
PrepYourData
2:27
Assigning Unique ID to cell value using IF formula in excel
91.6K views
May 12, 2019
YouTube
Wilson Powlous
17:35
Basic Excel: multi-variable linear regression + categorical variable
24.8K views
Mar 27, 2021
YouTube
Hubert Pun
3:55
How To Get Unique Values From Two Columns In Excel || Excel Tip
…
106.7K views
Nov 8, 2019
YouTube
dptutorials
4:46
Use Excel 2016 to make Frequency table for categorical data
98K views
Jul 26, 2016
YouTube
Kwai Chan
18:43
Generate unique IDs for your dataset for building summary repo
…
52.1K views
May 4, 2021
YouTube
KeyCuts
2:56
How to create a Unique code in excel/How to generate random ch
…
136.4K views
Mar 24, 2017
YouTube
Shuaib Khan
See more videos
More like this
Feedback