日期格式实际是数值类型转换为日期类型
http://oa.bestwaycorp.com:889
EXCEL中查找前一数据A27是否存在后列B中:=IF(COUNTIF(B:B,A27),A27,0)
EXCEL中查找前一数据Sheet2中A27是否存在后列B中:=IF(COUNTIF(Sheet2!A:A,A27),A27,0)
EXCEL中查找A2数据在E列中出现次数:=COUNTIF(E:E,A2)
setpointer()
SetItemStatus
setconnect()
Describe()
Space()
GetDynamicDate
send(handle,message#,lowword,long)
getbandatpointer()
sqlda,sqlsa
expression
coalesce
kill
excel中替换换行:=SUBSTITUTE(SUBSTITUTE(J2129,CHAR(10)," "),CHAR(13),"")
表格1中根据序号与表格2中序号匹配,读取表格2中数据
=VLOOKUP(A2,[2.xlsx]Sheet1!$A:$B,2,0)
