This is such an excellent way to compare two lists or data in Excel using the Filter Function along with the Sort, CountIf and IfError functions. You get a list of all the missing records from one table compared to another and vice versa. Visually list missing data when comparing two lists. Sample File: Microsoft Tips and Tricks and learning how to be more efficient and effective #comparetwolists #exceltips #exceltricks