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
Shorts
0:13
1.9M views
2.9M views · 9K reactions | Our long awaited 24” check in restock is...
MiaMily Official
0:20
2K views
How to Combine Name & Surname in Excel using Formula | Excel Tips
Easy Tricks
Excel List Tutorial
47:31
Learn Microsoft Excel Tutorial For Beginners in UNDER 45 MINUTES! (Microsoft Office 365 Excel)
YouTube
MyExcelOnline.com
153.6K views
Mar 12, 2021
54:55
Excel for Beginners - The Complete Course
YouTube
Technology for Teachers and
12.8M views
Aug 22, 2022
5:43:05
The Ultimate Excel Tutorial - Beginner to Advanced - 5 Hours!
YouTube
Simon Sez IT
1.8M views
Dec 6, 2021
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
Excel Data Validation
4:22:11
Microsoft Excel 365 Tutorial: 4-Hour Beginner Excel Training Course
YouTube
Simon Sez IT
109K views
Dec 5, 2023
11:54
How to create a spreadsheet in excel in 5 minutes | excel for beginners
YouTube
Learning MsOffice
1.4M views
Jun 3, 2023
11:55:34
Excel Tutorial Beginner to Advanced - 12-Hour Excel Course
YouTube
Simon Sez IT
1.1M views
Jan 25, 2023
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
If cell contains
Dec 14, 2023
exceljet.net
Named Ranges in Excel
Oct 24, 2023
exceljet.net
How to Split or Reverse First Last Names in Excel
2 months ago
contextures.com
0:27
3.4M views · 16K reactions | Create a List of Names by comparing two li
…
993.1K views
2 weeks ago
Facebook
Excel Basement
Value exists in a range
Oct 26, 2022
exceljet.net
If cell contains one of many things
Oct 26, 2022
exceljet.net
0:20
How to Combine Name & Surname in Excel using Formula | Excel Tips
2K views
2 weeks ago
YouTube
Easy Tricks
0:32
বড় সিদ্ধান্ত নিল মোদি সরকার রেশন কার্ড বাতি
…
1M views
2 weeks ago
YouTube
The United India
2:00
Using Named Cells in the IF Function in Excel
3K views
Jun 22, 2015
YouTube
Adam Gaweda
Worksheet name exists
Oct 26, 2022
exceljet.net
1:38
How to paste a list of defined names
20.3K views
Mar 2, 2017
YouTube
Techie_RENAE_K_CLARK
5:35
find names starting with certain character -Excel
7.5K views
Dec 30, 2022
YouTube
ExcelMoments
3:44
Naming Cells in Excel
140.6K views
May 10, 2012
YouTube
LearnChemE
5:14
Excel Split Names Tutorial
559.1K views
Oct 16, 2017
YouTube
Technology for Teachers and Students
11:24
How To Extract A Dynamic List From A Data Range Based On A C
…
109.9K views
Jan 30, 2017
YouTube
Excel Bytes
4:18
Introduction to Naming Cells in Excel
11.6K views
Aug 25, 2020
YouTube
Matt Macarty
4:34
Finding All Linked Cells In A Workbook
39.2K views
Jul 24, 2017
YouTube
K2 Enterprises
4:25
How to Separate Names in Excel
205.6K views
Jan 14, 2020
YouTube
Kevin Stratvert
9:11
Microsoft Lists - create a list from Excel
40.1K views
Jun 13, 2020
YouTube
Mark Kashman
4:11
How to Create Nametags From Excel : Microsoft Office Tips
61.6K views
Oct 18, 2013
YouTube
eHowTech
6:42
How to Get All Sheet Names in Excel Using Formula | List All Sheet Na
…
35.4K views
Jun 26, 2021
YouTube
MANOJ KUMAR EXCEL
5:57
Excel: If Cell Contains ONE of MANY THINGS
79.7K views
Jun 8, 2020
YouTube
Chester Tugwell
13:43
Searchable Drop-Down List in Excel - The Easy Way
109.9K views
Jan 28, 2020
YouTube
Computergaga
See more videos
More like this
Feedback