Hi. I have list A that I am comparing with list B. I want to see which people from list A are in list B. I started with a "CountIf" formula. I made the range all of list B, and the criteria each name in list B. I put a "$" sign in front of the range so it would remain constant, but it doesn't work. Please help!
Solved by S. A. in 22 mins