Forum Discussion
Compare customer institutes names between 2 columns
Good afternoon, I have 2 columns with in both some text (they contain a list with customer names which can be a single word but also longer institute name as in "the university of ......). I want t...
Ronald_DaasYou could try:
1. =COUNTIF(I1:I1,J1)=0
In my example, I1 is the first column and J1 is the second column.
2. Highlight the first column that you are comparing to the second column. So you would Select the Entire first column as your range.
Hope this helps.
- Thank you Imk - I will give that a try
Regards,
Ronald
