Hi, I have a list of names in column 1 and another list of names in column 2.
I would like to count how many of the names in column 2 are in column 1. I
have a feeling it will be countif but because the criteria is a range I can't
get it to work.
Any help would be appreciated.
Thanks.