Search text within Text

[msharma864512]

Hi,

I want to search a certain set of keywords within a data range. And whenever the desired keywords are mentioned in the data range, please filter them or add a column after B to differentiate the companies wherein the keywords are present and where keywords are not present.

Regards,
Manish

 

[Nebu]

Hi:

May be this?

Thanks

 

[msharma864512]

Hi:

May be this?

Thanks

Hi Nebu,

Thanks for the quick response and this is really very helpful.

But in this case, it is returning the text which is matching the range.

Will it be possible to just return Include/Exclude only.

 

[Nebu]

Hi:

Wrap the formula in a if condition like If(istext(formula), "Include","Exclude")

Thanks

 

[msharma864512]

T

Hi:

Wrap the formula in a if condition like If(istext(formula), "Include","Exclude")

Thanks

Thats perfect, very helpful, thank u vei much.