Excel Trick: Find Missing Data Between 2 Lists in Seconds!
Published
About this short
Learn how to find missing data between two lists in MS Excel using XLOOKUP, COUNTIF, and Conditional Formatting.
In this short tutorial, you will learn:
How to compare two lists in Excel
How to find missing names or values
How to use XLOOKUP
How to use COUNTIF
How to highlight missing values with Conditional Formatting
This trick is very useful for:
Student records
Attendance sheets
Sales lists
Employee data
Comparing two Excel lists quickly
PEARL INSTITUTE BATALA
Website: pearlinstitute.in
Contact: 7814976999
