LinkBack URL
About LinkBacks
Sounds like you want to know if a word in the bottom block appears in the top block. If so, 1, if not, 0
Try
=IF(COUNTIF($A$1:$E$4,A7)>0,1,0)
Is that what you are looking for?
Sounds like you want to know if a word in the bottom block appears in the top block. If so, 1, if not, 0
Try
=IF(COUNTIF($A$1:$E$4,A7)>0,1,0)
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
Yes! This is actually perfect.
However, I want run a count if using ALL the words in the bottom block at once. Is there anyway I can apply this formula, to search for all the words in the bottom block at one time?
Array formula (use CNTRL SHFT ENTER instead of Enter. You'll see brackets appear around the formula{})
=SUM(--(COUNTIF($A$1:$E$4,A7:E7)>0))
You're a genius man...
Thank you so much
out of curiosity, what do the two little dashes in the parentheses before COUNTIF do?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks