Thread: difference between two word lists

Could use something like:

Code:

=COUNTIF($B$1:$B$100,$A1)

where column b was the list you were comparing to column a, and this was in row 1 in say, column c. Drag down.

0's would be ones that weren't in both lists.
Could throw in a
=if(countif(b1:b100,a1)=0,"Not listed","listed")
if you wanted it to give you a text readout.

mew!