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.
6 months ago
Microsoft Excel Excel Tips and Tricks
25:38
Top 20 Microsoft Excel Tips & Tricks
YouTube
Kevin Stratvert
861.7K views
Oct 23, 2020
50:17
50 Ultimate Excel Tips and Tricks for 2020
YouTube
Sele Training
1.9M views
Mar 17, 2020
45:38
31 Excel Tricks that everyone should know!
YouTube
Learn More
154.8K views
11 months ago
Top videos
Get first name from name
exceljet.net
Oct 26, 2022
8:13
How To Compare Multiple Lists of Names with a Pivot Table - Excel Campus
excelcampus.com
Jul 8, 2014
Get last name from name
exceljet.net
Oct 26, 2022
Microsoft Excel Excel Formulas
1:38
How to create formulas in Microsoft Excel
YouTube
Microsoft 365
414.4K views
Feb 17, 2021
26:26
How to use Formulas and Functions in Microsoft Excel
YouTube
Teacher's Tech
446.1K views
Apr 19, 2021
27:19
Top 10 Most Important Excel Formulas - Made Easy!
YouTube
The Organic Chemistry Tutor
8.4M views
Jun 8, 2018
Get first name from name
Oct 26, 2022
exceljet.net
8:13
How To Compare Multiple Lists of Names with a Pivot Table - Excel
…
Jul 8, 2014
excelcampus.com
Get last name from name
Oct 26, 2022
exceljet.net
3:39
How to Quickly Find Hyperlinks in Excel (using Find and Replace)
Aug 29, 2016
trumpexcel.com
5:38
How to Fix the Excel Name Error? 3 Simple Tips
Jun 8, 2022
simonsezit.com
List sheet names with formula
Mar 20, 2024
exceljet.net
Named Ranges in Excel
Oct 24, 2023
exceljet.net
How to Split or Reverse First Last Names in Excel
3 months ago
contextures.com
0:27
3.4M views | Reel by Excel Basement
993.2K views
2 weeks ago
Facebook
Excel Basement
Value exists in a range
May 11, 2024
exceljet.net
Switch First & Last Names w/ Commas - Excel & Google Sheets
Feb 8, 2023
automateexcel.com
If cell contains one of many things
Nov 9, 2021
exceljet.net
6:18
SBM 2.0 List Check 2025 | New Beneficiary Name Check | Comple
…
4K views
1 week ago
YouTube
Bharali's Info
0:32
How to Correct Full Names in Excel (EASY & FAST!) #exceltricks #dat
…
2.1K views
1 month ago
YouTube
Orbit Animation
12:27
SECRET Excel Named Range Shortcuts to Save Time
54.7K views
Apr 28, 2022
YouTube
MyOnlineTrainingHub
4:37
Excel: Check IF RANGE of Cells Contains SPECIFIC TEXT
112.9K views
Jun 3, 2020
YouTube
Chester Tugwell
12:19
Microsoft Excel Dynamic Search List using Data Validation & Form
…
3.4K views
Jun 23, 2021
YouTube
MyExcelOnline.com
0:21
Did you know that you can NAME your Excel cells (and reference th
…
1.1K views
Feb 22, 2024
TikTok
miss.excel
1:38
How to paste a list of defined names
20.7K views
Mar 2, 2017
YouTube
Techie_RENAE_K_CLARK
How to Create a Dynamic Names List Based on Status in Excel
6 months ago
YouTube
vlogize
5:35
find names starting with certain character -Excel
7.5K views
Dec 30, 2022
YouTube
ExcelMoments
3:44
Naming Cells in Excel
140.7K views
May 10, 2012
YouTube
LearnChemE
5:14
Excel Split Names Tutorial
567.6K views
Oct 16, 2017
YouTube
Technology for Teachers and Students
2:43
Change Excel Named Range Address - Include New Items
60.1K views
Mar 9, 2014
YouTube
Contextures Inc.
1:43
Using named cells in Excel
163 views
Sep 11, 2019
YouTube
IV, STAT!
4:34
Finding All Linked Cells In A Workbook
39.9K views
Jul 24, 2017
YouTube
K2 Enterprises
8:56
How to Create Mailing Labels in Word From an Excel List
213.8K views
Dec 3, 2020
YouTube
Simple Software Tutorials
9:11
Microsoft Lists - create a list from Excel
40.4K views
Jun 13, 2020
YouTube
Mark Kashman
4:11
How to Create Nametags From Excel : Microsoft Office Tips
61.8K views
Oct 18, 2013
YouTube
eHowTech
See more videos
More like this
Feedback