Find The Existence Of A String In Other Column

Sibeesh Venu
Feb 28 2016
Code

In this post we will see how we can find the existence of a string in other columns in Excel. We will be using a single excel formula to do this task. I hope you will like this.

=COUNTIF(A1:A80,"*"&B2&"*")> 0

Here we are checking the value of B2 cell is existed anywhere in column A. If the value exists, it will return TRUE or FALSE.

Please see my other posts code snippets here: Code Snippets.