Excel Formula: Count Matches in Both Lists. Conditional Formatting to Format Matches. EMT 1613

Download Excel File: https://ift.tt/2BxapfF
Learn about how to create a Single Cell Formula to Count the Number of Matches In Two Lists with the MATCH and COUNT Functions. Also learn hos to add Conditional Formatting to highlight values that are in both lists.
Topics:
1. (00:01) Intro
2. (00:21) Single Cell Formula to Count the Number of Matches In Two Lists
3. (03:46) Conditional Formatting to Highlight Matches In Two Lists
4. (03:30) Summary

View on YouTube