|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
不难,只是又烦又繁:所处单元格位置(A3:L10)不固定,只好通过四项内容分别查找+分隔符号“拼接”而成(以冒号为查找关键字,故要求冒号要统一,原附件冒号有单字节也有双字节的,改了):
=MID(INDIRECT(TEXT(MIN(IF(ISNUMBER(FIND("合同号",A3:L10)),ROW(3:10)*100+COLUMN(A:L))),"R0C00"),),FIND(":",INDIRECT(TEXT(MIN(IF(ISNUMBER(FIND("合同号",A3:L10)),ROW(3:10)*100+COLUMN(A:L))),"R0C00"),))+1,20)&"("&MID(INDIRECT(TEXT(MIN(IF(ISNUMBER(FIND("业主姓名",A3:L10)),ROW(3:10)*100+COLUMN(A:L))),"R0C00"),),FIND(":",INDIRECT(TEXT(MIN(IF(ISNUMBER(FIND("业主姓名",A3:L10)),ROW(3:10)*100+COLUMN(A:L))),"R0C00"),))+1,10)&"-"&MID(INDIRECT(TEXT(MIN(IF(ISNUMBER(FIND("首付",A3:L10)),ROW(3:10)*100+COLUMN(A:L))),"R0C00"),),FIND(":",INDIRECT(TEXT(MIN(IF(ISNUMBER(FIND("首付",A3:L10)),ROW(3:10)*100+COLUMN(A:L))),"R0C00"),))+1,15)&"-"&MID(INDIRECT(TEXT(MIN(IF(ISNUMBER(FIND("房号",A3:L10)),ROW(3:10)*100+COLUMN(A:L))),"R0C00"),),FIND(":",INDIRECT(TEXT(MIN(IF(ISNUMBER(FIND("房号",A3:L10)),ROW(3:10)*100+COLUMN(A:L))),"R0C00"),))+1,10)&")"
EH(Wjg)c.rar
(8.26 KB, 下载次数: 4)
|
评分
-
1
查看全部评分
-
|