如何根据层级取上级编码，一级显示为空，二级显示一级编码

zl975798 · 发表于 2024-10-26 13:29

sqrall900 · 发表于 2024-10-26 14:30

=IF(E2=1,"",LOOKUP(1,0/(E2-1=E$2:E2),F$2:$F2))

wintroop · 发表于 2024-10-26 15:00

=IFERROR(LEFT(F2,FIND("@",SUBSTITUTE(F2,".","@",LEN(F2)-LEN(SUBSTITUTE(F2,".",""))))-1),"")

zl975798 · 发表于 2024-10-26 15:07

wintroop 发表于 2024-10-26 15:00
=IFERROR(LEFT(F2,FIND("@",SUBSTITUTE(F2,".","@",LEN(F2)-LEN(SUBSTITUTE(F2,".",""))))-1),"")

是我想要的，感谢

zl975798 · 发表于 2024-10-26 15:08

sqrall900 发表于 2024-10-26 14:30
=IF(E2=1,"",LOOKUP(1,0/(E2-1=E$2:E2),F$2:$F2))

感谢

你是那块小饼干 · 发表于 2024-10-26 16:28

=IF(E2<>1,TEXTBEFORE(F2,".",1),"")

		自动登录	找回密码
密码			免费注册

[求助] 如何根据层级取上级编码，一级显示为空，二级显示一级编码