"*BETWEEN*"
What does:
IF(COUNTIF(D2,"*Honda*"),"Honda",D2) this formula do?? i.e. what do the *______* accomplish?? Thanks, FLKulchar |
"*BETWEEN*"
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 "F. Lawrence Kulchar" wrote: What does: IF(COUNTIF(D2,"*Honda*"),"Honda",D2) this formula do?? i.e. what do the *______* accomplish?? Thanks, FLKulchar |
All times are GMT +1. The time now is 01:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com