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)
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