Excel常用函数Excel篇

字符串拼接

="INSERT into chars(chars.cr)VALUES ( "&A1&");"

长度计算

=LEN(A1)

大写

=UPPER(A1)

小写

=LOWER(A1)

首字母大写

=PROPER(A1)

去重复

=IFERROR(INDEX(C:C,SMALL(IF(MATCH($C$2:$C$100,$C$2:$C$100,0)=ROW($C$2:$C$100)-1,ROW($C$2:$C$100)),ROW(C1))),"")

求多个sheet，相同列的最大值，比如 Sheet1=>C1:C100 Sheet2=>C1:C100

=MAX(Sheet开始名字:Sheet结束名字!C1)

求多个sheet，相同列的最小值，比如 Sheet1=>C1:C100 Sheet2=>C1:C100

=MIN(Sheet开始名字:Sheet结束名字!C1)