All
Search
Images
Videos
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
List missing values
To compare two lists and pull missing values into a new list, you can use the FILTER function. In the example shown, the formula in cell F5 is: =FILTER(list1,NOT(COUNTIF(list2,list1))) where list1 (B5:B16) and list2 (D5:D12) are named ranges. The result is the names in B5:B16 that do not appear in D5:D12.
Apr 30, 2023
Excel Unique Values
5:32:33
🔥 Excel Full Course For Beginners | Excel Basics Training Course 2023 | Simplilearn
YouTube
Simplilearn
162.3K views
Sep 30, 2023
31:45
How to use Microsoft Excel - Beginner to Intermediate Class (with sample files)
YouTube
Chandoo
458.3K views
Oct 5, 2021
10:40:33
🔥 Complete Excel Course: Beginner To Expert | Advanced Excel Tutorial | Excel Training | Simplilearn
YouTube
Simplilearn
313.1K views
Jul 21, 2023
Top videos
Find missing values
exceljet.net
Oct 26, 2022
9:01
Excel Basics: How to add drop down list to a cell to validate data
chandoo.org
Sep 28, 2021
How to Show a List of Values in a Cell in Excel
chron.com
Jul 11, 2013
Excel Data Analysis
3:56:43
Complete Excel Tutorial for Data Analysis in 4 Hours (with FREE Files)
YouTube
Chandoo
331.4K views
8 months ago
11:54:55
Excel For Data Analysis Full Course 2025 | Excel Data Analytics Tutorial For Beginners | Simplilearn
YouTube
Simplilearn
13.7K views
6 months ago
12:09
Learn 80% of Data Analysis in Excel in Just 12 Minutes
YouTube
Kenji Explains
119.6K views
7 months ago
Find missing values
Oct 26, 2022
exceljet.net
9:01
Excel Basics: How to add drop down list to a cell to validate data
Sep 28, 2021
chandoo.org
How to Show a List of Values in a Cell in Excel
Jul 11, 2013
chron.com
0:21
22K views · 200 reactions | Identifying Missing Values: Using
…
6.3K views
1 week ago
Facebook
Excel Formulas Unleashed
Compare Two Excel Lists To Highlight Missing Items
Mar 11, 2014
howtoexcelatexcel.com
5:49
Easily Create a Drop-Down List in Microsoft Excel: Setup & Customi
…
1.3M views
5 months ago
wikiHow
Kyle Smith
How to Create a Drop Down List in Excel
Apr 4, 2021
goskills.com
How to quickly remove rows that have empty values
Oct 28, 2022
exceljet.net
How to fill in missing data with a simple formula
Oct 26, 2022
exceljet.net
List Skipped Numbers in Sequence - Excel & Google Sheets
Aug 17, 2023
automateexcel.com
4 Ways to Create Numbered Lists in Excel - Excel Campus
Apr 12, 2022
excelcampus.com
5 Ways to Find and Remove Blank Spaces in Excel - Excel Campus
Sep 28, 2021
excelcampus.com
Find Missing Values - Excel & Google Sheets
Nov 28, 2020
automateexcel.com
7:29
🔎Get The Missing Number from the list | Dynamic Arrays | macOS & W
…
7.7K views
Jun 3, 2019
YouTube
Faraz Shaikh
Compare two lists to find missing values using VLOOKUP in Excel -
…
Jun 5, 2024
reddit
xybernetics
Count missing values
Oct 26, 2022
exceljet.net
How To List missing Numbers in a sequence
1.4K views
Mar 30, 2023
YouTube
CrispExcel Training & Consulting
12:26
How to Create a Searchable Drop-down List in Excel
23.1K views
Jul 12, 2019
YouTube
Chester Tugwell
4:08
Highlight Missing Values in Excel with VLOOKUP
65.7K views
Apr 17, 2013
YouTube
Computergaga
5:43
2b Cleaning for missing data by filtering in Excel
5.1K views
May 16, 2019
YouTube
MEI
3:19
How to Create Custom Lists in Excel
115.5K views
Jul 24, 2018
YouTube
MDTechVideos
9:11
Microsoft Lists - create a list from Excel
40.1K views
Jun 13, 2020
YouTube
Mark Kashman
5:57
Microsoft Lists | Three Tips for Creating Lists
62.5K views
Aug 27, 2020
YouTube
Collaboration Coach
3:37
How To Create Drop Down List and Display Different Values In Excel
87.2K views
Dec 2, 2020
YouTube
Excel 10 tutorial
22:18
Create a Searchable Drop Down List in Excel
84.8K views
Sep 5, 2018
YouTube
Officeinstructor
13:43
Searchable Drop-Down List in Excel - The Easy Way
109.5K views
Jan 28, 2020
YouTube
Computergaga
4:09
How to Create a Drop Down List in Excel
473.9K views
Jul 27, 2019
YouTube
Max Dalton
18:37
🔎 How to Create Searchable Drop Down List in Excel
401.9K views
Jul 19, 2021
YouTube
Kevin Stratvert
2:59
Excel Row Numbering: Number The Visible Rows - Episode 2328
33.1K views
Mar 26, 2020
YouTube
MrExcel.com
See more videos
More like this
Feedback