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

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.