I need a macro that compares a list of words

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,


I have an Excel sheet with a list of words in a column C. I Need a macro that compares the list of words in column C cell by cell with a list of words. When it reach a cell that contains a word not in the list it stops lets me fix the value and then moves on to evaluate the remaining cells.

Is this possible?

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
i do not know the purpose of this . you need not have a macro suppose colulmn C
from c1 down is like this

s
f
d
a
g
h
j
k
In column F is the list
s
f
j

in D1 type this formula
=COUNTIF($F$1:$F$3,C1)
copy D1 down.

the C value in the row where you get the first 0 you get column D is your cell
for e.g. in the above case it is C3.