随笔分类 - Excel
摘要:=IF(C3="","",IF(IFERROR(VLOOKUP(C3,E:E,1,),"") <> "", "〇","×")) =IF(IFERROR(VLOOKUP(E3,C:C,1,),"") <> "", "〇","×") =IF(D3="×",IF(C3,"",""),&quo
阅读全文
摘要:=IF(IFERROR(VLOOKUP(C3,D:D,1,),"")<>"","〇","")
阅读全文
摘要:strSearch 是被查找的内容strReplace 是替换的内容 Sub FindAndReplace(ByVal strSearch As String, ByVal strReplace As String) Cells.Replace What:=strSearch, Replacemen
阅读全文
摘要:Sheet1.Range("1:" & Sheet1.Rows.Count).Find("测试字符串").Address excel 中查找字符串并返回该单元格的位置 若字符串在查找区域是唯一的,可简单用函数解决。示例:要求在 A1:C10 区域内,查找存在字符串“str”的单元格,返回该单元 格地
阅读全文
摘要:1、java开发必备工具 DB字段名转驼峰(Excel) =LOWER(LEFT(A:A,1))&MID(SUBSTITUTE(PROPER(A:A),"_",""),2,100)
阅读全文