Find The Existence Of A String In Other Column

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.

[csharp]
=COUNTIF(A1:A80,"*"&B2&"*")> 0
[/csharp]

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

Kindest Regards
Sibeesh Venu

Leave a Reply

Your email address will not be published. Required fields are marked *

Serverless 360