5 Reasons to use COUNTIF - #3 Compare Two Lists

Compare two lists in Excel using the COUNTIF function. Comparing two lists is a very common Excel task. There are a few different approaches, but this video tutorial focuses on using the COUNTIF function. In the video, we look at checking two lists to find which names are missing from one of the lists. This video is the third in the '5 Alternative Reasons to use COUNTIF' series. The COUNTIF function is used to count records that meet specific criteria. It is one of the most useful functions in Excel, especially for analysing data and reporting. This video series looks at 5 alternative reasons to use the COUNTIF function. The other videos in the series can be found using the links below. #1 – Prevent Duplicate Entries in a Range - https://youtu.be/N2WV_rO_y2s #2 - Uniquely Rank Items in a List - https://youtu.be/QFdsGGlSmrU #4 - Create a Distinct Count Formula - https://youtu.be/sRUSLs6YaK0 #5 - Identify Names that Occur 3 or More Times - https://youtu.be/1CSpFBZk0X8