What does:
IF(COUNTIF(D2,"*Honda*"),"Honda",D2)
this formula do??
i.e. what do the *______* accomplish??
Thanks,
FLKulchar
Muhammed Rafeek M - 19 Sep 2006 06:34 GMT
it will search in D2 cell that is there anywhere "Honda" word in cell D2. if
it is there result will get "Honda" or what is there in D2
ex: D2: "Hero Honda" or D2: "Hero Honda Two wheelers"
those words u can see "honda", in that case u will get result "Hond"
pls do rate
> What does:
>
[quoted text clipped - 7 lines]
>
> FLKulchar