Excel Formula to find the Common Values between two Tables

Excel Formula to find the Common Values between two Lists or Tables.
🍏Playlist for Shorts on Excel
• Short videos on Excel ...
🍓Download my free eBook on Excel Macros
eepurl.com/gpT0RD
🍇Check these Books on Excel
xlncad.com/excel-resources/
🍉Read my articles on Excel
xlncad.com/
🍐Join my online course on Excel Tables
www.udemy.com/course/tables-i...
#findduplicate #filterfunction #exceltips

[@satheeshpn1732]

❤ how to compare two pivot tables filtered, and count unique values
Thanks

[@user-vx4ku9em2h]

Very helpful 👌

[@DanielHartz]

This is really cool. Is there also a way to hide the duplicates?
I have two lists I compare each week. But with those lists I also have a unique number linked to the names, as well as an email address.
I’ve been trying to make one list of the duplicates, but then remove them from the original list.
Each list is for client communication, and the duplicates require different communication than the remaining names.