List missing values
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
Excel Formula Tutorial
Excel Formulas and Functions Tutorial
12:29
Excel Formulas and Functions Tutorial
YouTubeKevin Stratvert
3.9M viewsJul 13, 2019
Excel Formulas Tutorial for Beginners - Learn How to Use Basic Formulas & Functions Microsoft Excel
9:51
Excel Formulas Tutorial for Beginners - Learn How to Use Basic Formulas & Functions Microsoft Excel
YouTubeSubjectmoney
12.3K viewsDec 30, 2012
TOP 25 Basic Excel Formulas for Beginners (2025) | Step-by-Step Excel Guide
19:39
TOP 25 Basic Excel Formulas for Beginners (2025) | Step-by-Step Excel Guide
YouTubeSheetSkill
5.4K views3 months ago
Top videos
Find missing values
Find missing values
exceljet.net
May 1, 2023
Find Missing Values - Excel & Google Sheets
Find Missing Values - Excel & Google Sheets
automateexcel.com
Feb 8, 2023
Identifying Missing Values: Using COUNTIF and IF Functions in Excel! Learn how to find values in one list that are missing in another list using a formula based on the COUNTIF function combined with the IF function in Excel. Elevate your spreadsheet skills and dive into this tutorial to efficiently identify missing values between two lists. Watch, learn, and streamline your data comparison process with ease! 💻🔍📊 #ExcelTips #MissingValues #SpreadsheetSkills #DataComparison #ExcelMagic | Excel
0:21
Identifying Missing Values: Using COUNTIF and IF Functions in Excel! Learn how to find values in one list that are missing in another list using a formula based on the COUNTIF function combined with the IF function in Excel. Elevate your spreadsheet skills and dive into this tutorial to efficiently identify missing values between two lists. Watch, learn, and streamline your data comparison process with ease! 💻🔍📊 #ExcelTips #MissingValues #SpreadsheetSkills #DataComparison #ExcelMagic | Excel
FacebookExcel Formulas Unleashed
6.3K viewsMar 28, 2024
Excel Tips and Tricks
Amazing New Excel Feature – Analyze Data | Automatic Pivot Table & Pivot Chart
1:01
Amazing New Excel Feature – Analyze Data | Automatic Pivot Table & Pivot Chart
YouTubeIICA Computer Education
27.5K views1 month ago
How To Fill Numbers In Excel Quickly And Easily!
0:59
How To Fill Numbers In Excel Quickly And Easily!
YouTubeExcel Campus - Jon
1.4M viewsApr 18, 2023
New Excel Feature: Insert Picture In Cell
0:54
New Excel Feature: Insert Picture In Cell
YouTubeExcel Campus - Jon
256.5K viewsJun 6, 2023
Find missing values
Find missing values
May 1, 2023
exceljet.net
Find Missing Values - Excel & Google Sheets
Find Missing Values - Excel & Google Sheets
Feb 8, 2023
automateexcel.com
Identifying Missing Values: Using COUNTIF and IF Functions in Excel! Learn how to find values in one list that are missing in another list using a formula based on the COUNTIF function combined with the IF function in Excel. Elevate your spreadsheet skills and dive into this tutorial to efficiently identify missing values between two lists. Watch, learn, and streamline your data comparison process with ease! 💻🔍📊 #ExcelTips #MissingValues #SpreadsheetSkills #DataComparison #ExcelMagic | Excel
0:21
Identifying Missing Values: Using COUNTIF and IF Functions in Exc…
6.3K viewsMar 28, 2024
FacebookExcel Formulas Unleashed
Identify Missing IDs and Sequence Gaps - Excel University
6:49
Identify Missing IDs and Sequence Gaps - Excel University
Dec 10, 2018
excel-university.com
How to fill in missing data with a simple formula
How to fill in missing data with a simple formula
Oct 26, 2022
exceljet.net
5 Ways to Find and Remove Blank Spaces in Excel - Excel Campus
5 Ways to Find and Remove Blank Spaces in Excel - Excel Campus
Sep 28, 2021
excelcampus.com
How to Show Hidden Columns in an Excel Spreadsheet
7:43
How to Show Hidden Columns in an Excel Spreadsheet
790.1K views3 months ago
wikiHow
3:29
Google Sheets - Highlight Missing Values Between Two Columns
25.2K viewsJul 17, 2020
YouTubeProlific Oaktree
4:47
If Cell is Blank Then ... Return Value or Blank in Excel
488.6K viewsFeb 20, 2020
YouTubeChester Tugwell
14:21
How To Fix Common Excel Formula Errors
17.7K viewsAug 17, 2021
YouTubePete - HowToAnalyst
4:37
Excel: Check IF RANGE of Cells Contains SPECIFIC TEXT
113K viewsJun 3, 2020
YouTubeChester Tugwell
1:50
Excel - How to find cell with value in table full of formulas
4.6K viewsJan 27, 2022
YouTubeExcellent Ideas & Tips
Count missing values
Oct 26, 2022
exceljet.net
4:08
Highlight Missing Values in Excel with VLOOKUP
65.7K viewsApr 17, 2013
YouTubeComputergaga
1:40
How to find missing values | How to find missing values using if and c…
3.4K viewsJul 20, 2020
YouTubekarpagam Excel Prime
9:02
How to Cell Reference in Excel
167.2K viewsDec 31, 2019
YouTubeKevin Stratvert
3:01
How to use FIND Formula in Excel
136.8K viewsMar 12, 2014
YouTubeTrumpExcel
3:13
How to use the FIND function in Excel
295.9K viewsMay 12, 2019
YouTubeTechOnTheNet
11:24
Excel - Find Numbers Between Range | FILTER & VLOOKUP to Fi…
94.1K viewsApr 21, 2021
YouTubeChester Tugwell
2:30
How To Find Same Values in Different Sheets in Microsoft Excel
90.3K viewsApr 29, 2020
YouTubeQuikDIY
3:00
Excel Tutorial: Find Missing Numbers
93.1K viewsJul 12, 2007
YouTubevideoturo
3:59
HOW TO DELETE BLANK ROWS WITHOUT LOSING DATA [THE RIG…
139.4K viewsJun 11, 2021
YouTubeSpreadsheeto
10:01
How to Remove Hidden Data and Personal Information from Excel …
70.8K viewsApr 6, 2016
YouTubeLeila Gharani
2:36
How to find missing values with COUNTIF
55.5K viewsJun 17, 2016
YouTubeExceljet
1:56
Excel - hiding, unhiding and locating hidden cells
90.3K viewsOct 23, 2012
YouTubeExcel at Work
9:01
"how To Fix Excel Formulas That Aren't Calculating Or Updating"
133.1K viewsJul 22, 2021
YouTubeExcel Campus - Jon
3:56
Excel - Fill in empty cells with data from the cell above
224.5K viewsApr 22, 2016
YouTubeIQ Accounting Solutions
1:16
Find or replace text and numbers in Microsoft Excel
212.8K viewsFeb 7, 2021
YouTubeMicrosoft 365
3:25
How to fill in missing data in Microsoft Excel
28.8K viewsFeb 25, 2020
YouTubeXceleration - The Excel Learning Channel
See more videos
Static thumbnail place holder