包罗万象--好东西要收藏--共享无限

  len函数和lenb函数都可以获得一个字符串的长度.不同的是len获得的字符个数，lenb是以字节为单位。一个字符=2个字节。汉字占两个字节。数字和字母均占一个字节，所以我们可以用以下公式判断字符串中是否包括汉字。

  =if(lenb(a1)>len(a1),"包括汉字","不含汉字")

兰色说:excel里带b的函数均为以字节数为单位的，如leftb,searchb..函数。

http://www.excelpx.com/HOME/show.aspx?id=35473&cid=18

方法2 数组公式:

=IF(SUM((MID(A1,ROW($1:$20),1)>"啊")*1),"有汉字","无汉字")

按CTRL+SHIFT+ENTER结束公式

http://club.excelhome.net/thread-1117005-1-1.html

希望对你有用.

方案一
$arr = array("0a","1b","2c","3d","4e","5f","6g","0a","2c","4e","6g","6g");
$arr1 = array_flip($arr);
$arr2 = array_flip($arr1);
print_r($arr2);
方案二
$arr = array("0a","1b","2c","3d","4e","5f","6g","0a","2c","4e","6g","6g");
$a = array_count_values($arr);
$b = array_keys($a);
print_r($b);
方案三
$arr = array("0a","1b","2c","3d","4e","5f","6g","0a","2c","4e","6g","6g");
foreach($arr as $k=>$v){
$arr1[$v] = $k;
$arr2 = array_flip($arr1);
}
print_r($arr2);
方案四
$arr = array("0a","1b","2c","3d","4e","5f","6g","0a","2c","4e","6g","6g");
$arr1 = array_unique($arr);
print_r($arr1);

都是刚刚我实验出来的  都可以封装起来用递归实现多维去掉重复项