Excel实用命令

公式包含两个sheet表，如果sheet2中A2的值，可以在sheet1中的A列找到，那C列为空，如果在sheet1中A列找不到，那就吧Sheet2的A列写到Sheet2的C列

=IF(IFERROR(VLOOKUP(A1,Sheet1!A:A,1,0),"")=A1,"",A1)

加一个带说明的图

Excel提取最后一个""前面的数据

=IFERROR(RIGHT(E1,LEN(E1)-FIND("",SUBSTITUTE(E1,"","",LEN(E1)-LEN(SUBSTITUTE(E1,"",""))))),"")
=IFERROR(RIGHT(E1,LEN(E1)-FIND("",SUBSTITUTE(E1,"","",LEN(E1)-LEN(SUBSTITUTE(E1,"",""))))),"")
LEN(E1)-LEN(SUBSTITUTE(E1,"",""))