I cant do that, I am waiting your hepls

Hi,

Here is a samplde code to achieve the same..

I have tested only two criteria... if the column contain "ltd" or "std" then it will print 1 otherwise it will print 0..

You can extend this formula to achieve the result you want

Please Login or Register  to view this content.

Originally Posted by NALAN

Hi , Firstly my Engilish is not enaugh good. If you help me, I will be happy . I have a cloumn in excel and the column have the company names. I search some word (ltd, sti, oto .....ext.) in column and I want to put a cod across the cell . For example :

Ornek ltd 1
Bu sti 1
Yok ki 0
Buda yok 0
Oto var 1

First row contains my words (ltd, sti, oto ....ext.) then put 1 and third row doesn’t cointain (ltd, sti, oto ext.) then put 0. Btw I know excel have contains filters. But excel doensnt permission extra 2 . I hope I can explain what I want Thanks

Please take the time to read the Forum Rules & use a descriptive title for your questions

You alter your title first as per Roy's request