Not much elsexcept there is a master list of names in A:A with a smaller list in B:B.
Trying to come up with an array that will tell me how many of the names in ColB are actually a part of the master list in ColA.
note: if a name in ColB "is" in ColA it would only be once. So, it feels like I'm trying to count the number of TRUE returns.
Why you don't use countif to count how many times?
or if you want to count matches, then a sumproduct: =SUMPRODUCT(--(A2:A100=B2:B10))
Click the * to say thanks.
Try
=SUMPRODUCT(COUNTIF(A2:A1000,B2:B100))
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
thanks a great deal. I'll put those to work.
I think I was over-thinking the process.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks