LinkBack URL
About LinkBacks
Let's say your original block is in A1:E4 and your second block is in row 7
Directly under Horse (in A8)
=COUNTIF($A$1:$E$4,A7) dragged/copied to the right.
Is that what you are looking for?
Let's say your original block is in A1:E4 and your second block is in row 7
Directly under Horse (in A8)
=COUNTIF($A$1:$E$4,A7) dragged/copied to the right.
Is that what you are looking for?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks for the reply Chemist, but no, this wouldn't help.
I want the COUNTIF to count ANY of the terms in the second block. (i.e. it would scan the top block for any of Horse Bear Red Blue Dog, and provide the count of the matching values)
Second, I want it to only count a matching value ONCE. For example, "Bear" appears on the top block twice, but I only want it to count ONCE if it matches. In other words, I only want unique matching values.
Does that make sense?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks