within a single cell I have following character values separated by ,
<tbody>
</tbody>
I have a lots of such entries that vary along the row for the same column no
I want to write a script to check 3 conditions and return the result accordingly
1. If the string contains "US" return 1
2. If the string contains "UK" return 2
3. If the string contains "US" and "UK" return 3
4. If the string contains "US" and "UK" and "FR" return 4
any formula or a VB script to do this effectively for variable rows and fixed column ?
Sanjog
VN,VI,VE,JP,TH,TW,HK,HM,HN,BR,PH,UM,NI,AR,BO,NZ,SG,KR,KH,ID,UY,SV,AW,US,PY,CR,MY,MF,CX,NF,PR,MO,CA,CC,GT,PA,EC,MX,AU,PE,AS,CN,CO |
<tbody>
</tbody>
I have a lots of such entries that vary along the row for the same column no
I want to write a script to check 3 conditions and return the result accordingly
1. If the string contains "US" return 1
2. If the string contains "UK" return 2
3. If the string contains "US" and "UK" return 3
4. If the string contains "US" and "UK" and "FR" return 4
any formula or a VB script to do this effectively for variable rows and fixed column ?
Sanjog