钉钉群联系导出整理公式&全称匹配简称lookup教程
| 钉钉群联系导出整理公式 | |||
|---|---|---|---|
| 群主 | =MOD(ROW(A2),2) | ||
| 皓渊 | =MOD(ROW(A3),2) | ||
| 杜渊 | =MOD(ROW(A4),2) | LEFT(A4,SEARCH("-",A4)-1) | =LEFT(A4,SEARCH(" ",A4)-1) |
| 苏 毅 | =MOD(ROW(A5),2) | =LEFT(A5,SEARCH(" ",A5)-1) |
| 全称匹配简称lookup教程 | ||
|---|---|---|
| 龙都 | 龙都* | =IF(ISNA(LOOKUP(1,0/FIND($A$1:$A$7,B1),$A$1:$A$7)),"未营业","已营业") |