Compare columns of text

  • Thread starter Thread starter Upstate
  • Start date Start date
U

Upstate

Hi

What is the best way to find if 10 words are in a column of 120 words?

Many thanks

AJ
 
Highlight the cells containing the 120 words you wish to search throug
and give the range a name (e.g. MyWords)
List the ten words you want to find in a separate column then, to th
right of each cell, type the following formula:

=COUNTIF(MyWords,B1)

Where MyWords is the name of the 120 word range and B1 is the cel
containing the word you wish to find. If the word is in the list th
formula will return 1, if not it will return 0
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT with criteria including OR function 4
Comparing columns of data 2
Excel Comparing two columns 1
Auto Sorting Data in Table 1
Look up value range in column and then count 3
Macro to add numbers in a text string 5
Printing Columns 1
Text to columns 2

Back
Top