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

Download Excel File:
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

Excel,Highline College,Mike Girvin,excelisfun,EMT,EMT 1613,Excel Magic Trick 1613,Excel Formula,Excel Formula To Count Matches in Both Lists,Conditional Formatting to Format Matches,Count items in both lists,formula to count items in both lists,MATCH and COUNT Functions,MATCH function,COUNT Function,Conditional Formatting to Highlight Matches In Two Lists,Format items in both lists,Count items in both columns,