How do I compare names in one column with names in another column to see how many times each name appears?
How do I compare names in one column with names in another column to see how many times each name appears?
If you had a list of unique names in column A, and a huge list of names in column C, place this in B1 and drag down to the end of the list of names in colulmn A.
=COUNTIF(C:C, A1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks