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.
8 months ago
Excel Formulas
0:59
How To Fill Numbers In Excel Quickly And Easily!
YouTube
Excel Campus - Jon
1.6M views
Apr 18, 2023
0:58
How To Calculate Percentage Change In Excel
YouTube
Excel Campus - Jon
156.7K views
Jun 14, 2023
5:02
Essential PivotTable Tips for Excel Beginners
TikTok
functional.excel
42.4K views
1 month ago
Top videos
Find missing values
exceljet.net
May 1, 2023
Get first text value in a range
exceljet.net
Jun 3, 2023
Find Missing Values - Excel & Google Sheets
automateexcel.com
Feb 8, 2023
Excel Tips and Tricks
25:38
Top 20 Microsoft Excel Tips & Tricks
YouTube
Kevin Stratvert
871.2K views
Oct 23, 2020
2:07:11
30 Essential Excel Tips and Tricks for 2024 - Excel Productivity Tutorial
YouTube
Simon Sez IT
100.2K views
Jan 9, 2024
50:17
50 Ultimate Excel Tips and Tricks for 2020
YouTube
Sele Training
1.9M views
Mar 17, 2020
Find missing values
May 1, 2023
exceljet.net
Get first text value in a range
Jun 3, 2023
exceljet.net
Find Missing Values - Excel & Google Sheets
Feb 8, 2023
automateexcel.com
Return blank if
May 24, 2023
exceljet.net
Lookup Last Value in Column or Row – Excel
Feb 8, 2023
automateexcel.com
Get value of last non-empty cell
Jun 17, 2023
exceljet.net
Finding Missing Numbers in a Range Using VBA • My Online Trai
…
Sep 11, 2013
myonlinetraininghub.com
Sum and ignore errors
Oct 26, 2022
exceljet.net
List Skipped Numbers in Sequence - Excel & Google Sheets
Aug 17, 2023
automateexcel.com
Find Last Row with Data - Excel & Google Sheets
Feb 8, 2023
automateexcel.com
6:55
VBA Tutorial: Find the Last Row, Column, or Cell in Excel
May 12, 2015
excelcampus.com
3:48
3 ways to remove carriage returns in Excel: formulas, VBA macro, find
…
98.5K views
Oct 25, 2016
ablebits.com
How to find missing numbers | MS Excel Tips & Tricks Tutorial |
4.1K views
Feb 8, 2023
YouTube
MH36 Excel
Find Missing Series Numbers | Step by Step | Excel Experts
8.6K views
Apr 11, 2018
YouTube
TechEase Solutions
6:08
Fixing Common Excel Errors - Part 3: REF and VALUE
59.2K views
Feb 13, 2020
YouTube
Technology for Teachers and Students
3:13
How to use the FIND function in Excel
300.9K views
May 12, 2019
YouTube
TechOnTheNet
1:37
How to Find a Value in Table or Range in Excel using VLOOKUP
35.4K views
Mar 13, 2019
YouTube
Niyas C
7:14
Five Ways To Fix #VALUE Errors in Microsoft Excel
129.5K views
Oct 10, 2018
YouTube
The Tech Train
11:24
Excel - Find Numbers Between Range | FILTER & VLOOKUP to Fi
…
95.2K views
Apr 21, 2021
YouTube
Chester Tugwell
4:10
Excel IF Range Contains Value | How to Perform an IF Statement o
…
105.8K views
Jul 1, 2021
YouTube
Chester Tugwell
1:04
How to filter or remove values in Microsoft Excel
45.6K views
Mar 3, 2021
YouTube
Microsoft 365
3:00
Excel Tutorial: Find Missing Numbers
93.1K views
Jul 12, 2007
YouTube
videoturo
3:59
HOW TO DELETE BLANK ROWS WITHOUT LOSING DATA [THE RIG
…
143K views
Jun 11, 2021
YouTube
Spreadsheeto
2:08
#REF Error in Excel
39.4K views
Mar 6, 2021
YouTube
Ajay Anand
5:58
Excel: Extract NonBlank or NonZero Values from an Array
42.2K views
Aug 15, 2015
YouTube
A Simple Model
6:22
Excel VBA Macro: Find and Replace Values in a Range (Step-by-Step T
…
29.5K views
Nov 23, 2019
YouTube
greggowaffles
0:30
How to Return a Value If a Cell Contains a Specific Text in Excel
89K views
Nov 14, 2018
YouTube
ExcelHow Tech
2:54
Using Excel Match function to row number of a text in a range
34.4K views
Aug 21, 2019
YouTube
Codible
18:54
8 Excel Functions that Return References - Do you know them all?
66.6K views
Jun 24, 2020
YouTube
MyOnlineTrainingHub
See more videos
More like this
Feedback